CODEWITHSUNDEEP
mysqlinstallationenvironment
Shaan
Shaan

Reputation: 873

I installed mysql 5.1 from the official site, but am having issues

NOTE: I am using Mac OS X Lion

Two issues in particular:

1) The server won't start when I try to start it from the pref pane

2) I get this error when I type "mysql" in the command line. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'


When I type mysqld, I get the following error:

120328 17:28:55 [Warning] Can't create test file /usr/local/mysql-5.1.62-osx10.6-x86_64/data/Shaans-MacBook-Pro.lower-test 120328 17:28:55 [Warning] Can't create test file /usr/local/mysql-5.1.62-osx10.6-x86_64/data/Shaans-MacBook-Pro.lower-test mysqld: Can't change dir to '/usr/local/mysql-5.1.62-osx10.6-x86_64/data/' (Errcode: 13) 120328 17:28:55 [ERROR] Aborting

120328 17:28:55 [Note] mysqld: Shutdown complete


When I type "sudo mysqld", I get the following error:

120328 17:45:48 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.1.62-osx10.6-x86_64/data/ is case insensitive 120328 17:45:48 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

120328 17:45:48 [ERROR] Aborting

120328 17:45:48 [Note] mysqld: Shutdown complete


When I type "sudo mysqld_safe", I get the following response:

120328 17:50:26 mysqld_safe Logging to '/usr/local/mysql/data/Shaans-MacBook-Pro.local.err'. 120328 17:50:26 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120328 17:50:32 mysqld_safe mysqld from pid file /usr/local/mysql/data/Shaans-MacBook-Pro.local.pid ended

Upvotes: 0

Views: 341

Answers (2)

keyz101
keyz101

Reputation: 26

Depending on what distro you have, these commands may work, I use Ubuntu Server 10.04

I type:
sudo service mysql stop
sudo service mysql start
sudo service mysql restart

To perform those functions

Upvotes: 0

Todd
Todd

Reputation: 922

Use mysqld to start the server - mysql starts the command line interface, not the daemon.

Upvotes: 1

Related Questions