Updating in mysql

08 Feb

You can check the running My SQL process using following command: ps auxf | grep mysql If you get any My SQL process kill that process ID using kill -9 PID and then try to start My SQL.120309 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120309 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 120309 [Warning] You need to use --log-bin to make --binlog-format work. 120309 Inno DB: The Inno DB memory heap is disabled 120309 Inno DB: Mutexes and rw_locks use GCC atomic builtins 120309 Inno DB: Compressed tables use zlib 1.2.3 120309 Inno DB: Initializing buffer pool, size = 16.0M 120309 Inno DB: Completed initialization of buffer pool 120309 Inno DB: Operating system error number 13 in a file operation.The directive to add looks like this: datadir = /usr/local/mysql/var Worked for me. I had this problem while trying to brew upgrade on Mac OS X 10.7.5.Unfortunately mysql was also upgraded to 5.6.10 from 5.5.14. I decided to go back to my old setup and did a It seems that My SQL process is running hence you are unable to use the port.

So I just edited /etc/and under the section [mysqld] I added a directive to explicitly point mysql's data directory to var (as I normally expect it to be any how), and after doing so, mysqld starts up just fine.

[mysqld] port = 3306 socket = /tmp/skip-external-locking key_buffer_size = 16K pid-file=/var/run/mysqld/[mysqld_safe] log-error=/var/log/pid-file=/var/run/mysqld/The solution that worked for me was here: https://serverfault.com/questions/334284/cant-create-pid-file-on-mysql-server-permission-denied Changing some of my permissions seemed to do the trick.

I'm running a Mid-2012 Macbook Air with OS X 10.8.2 and mysql was installed with homebrew. Please take note that you need to run mysql_install_db from the with top level of the mysql directory (IE, usr/local/Cellar/mysql/5.5.25).

You don't need to tho that to the alias since it's only an alias.

The name of the folder depends of the installation version of mysql that you have.