Mysql error
I have installed mysql via source code installtion, When i tried to start the service its giving error
[root@jacks tmp]# /usr/local/mysql/bin/mysqld start 111223 23:08:58 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 111223 23:08:58 [ERROR] Aborting 111223 23:08:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete [root@jacks mysql]# ./bin/mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) anyone plz help me at the earlist |
Basically mysql is complaining you're running mysql as root user and refuse to start.
I'd suggest you create user+group mysql, change your my.cnf so mysql runs as as user+group mysql. Alternatively, most distro has their own package manager which you could use to install mysql. That should put the reuqired configs/rights/user etc. in. What's your distro by the way? |
CentOS release 5.7 (Final)
i686 Dear aazkan, I have made all necessary owership and group cd /usr/local/mysql chown -R mysql chgrp -R mysql chown -R root . chown -R mysql data |
Hi,
If it's CentOS, a Code:
yum install mysql mysql-server Try Code:
chown -R mysql: /usr/local/mysql |
All times are GMT -5. The time now is 04:31 AM. |