Sunday, April 18, 2021

How to find a file in macOS Terminal using bash?

Cd into the directory. 

Example:
List down all the files with the name test.

 find . -type f -name "test*"

Additional tip

List down all the directories with the name test.

find . -type d -name "test*"

How to configure settings in php on MAMP ?

 The configuration file for php is php.ini.

The file is present in /etc directory.

Open a Terminal. Change to Root user.

bash#su -s
enter password

bash# cd /etc

bash# ls -l | grep php.ini

-rwxr-xr-x   1 root  wheel   72020 Apr 18 11:17 php.ini.default

bash# chmod 755 php.ini.default

Rename the file to pho.ini

mv php.ini.default

Edit the file and set the following settings if you wish too.

vi php.ini

To seach use /<word>

Userful settings

display_errors On
disaplay_start_errors - On
error_log /var/log/apache2/php_errors.log

write and quit

restart apache to reflect changes

bash#apachectl restart

Additional commands

php -v          -         version of php
php -m        -          modules installed like ssl, sockets etc.,
php -i            -        view php.ini configuration files

Saturday, April 17, 2021

Top 5 keywords associated with Beauty?

Words have meanings associated to it, some are synonyms like siblings and some are distant relatives like friends and associates.

Let's write the words down and you and I can later figure out our preferences to categorize them.

  1. Beauty
  2. Makeup?
  3. Dress
  4. Women
  5. Hair
  6. Wardrobe
  7. Face
  8. Beauty products



Friday, April 16, 2021

How to increase the font size of MacOS terminal?

Open a command Terminal. 

Use command + command - to increase or decrease the font size

How to solve InnoDB: Unable to lock ./ibdata1 mysql error? Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive

Problem Statement:

bash-3.2# /usr/local/mysql/support-files/mysql.server start


Starting MySQL
.................................................................................................... ERROR! The server quit without updating PID file (/usr/local/mysql/data/xx-xxx.pid).
bash-3.2# cat /usr/local/mysql/data/xx-xxxx.pid

 

Root Case :

There might be multiple mysql processes running. Kill them.

Solution:

bash-3.2# ps aux|grep mysql


root             28892   0.9  0.0  4277256    796 s001  S+    1:09PM   0:00.00 grep mysql
 

_mysql           22971   0.0  1.1  4884468 186036   ??  Ss    9:49AM   0:23.22 /usr/local/mysql/bin/mysqld --user=_mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/usr/local/mysql/data/mysqld.local.err --pid-file=/usr/local/mysql/data/mysqld.local.pid --keyring-file-data=/usr/local/mysql/keyring/keyring --early-plugin-load=keyring_file=keyring_file.so

sudo kill 22971

Restart the server

bash-3.2# /usr/local/mysql/support-files/mysql.server start

Starting MySQL
. SUCCESS!

Additional information

Error Messages from logs could look like:

bash-3.2# cat /usr/local/mysql/data/amoni-mac.err
2021-04-16T07:05:06.321323Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) starting as process 27393
2021-04-16T07:05:06.324284Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
2021-04-16T07:05:06.342917Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-16T07:05:06.365435Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 35
2021-04-16T07:05:07.368910Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 35
2021-04-16T07:05:08.372637Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 35