mysql启动问题: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
问题如标题,我是按照以下做的 我首先把mysql-5.0.22.tar.gz 拷贝到/usr/local目录下
#cd /usr/local# tar zxvf mysql-5.0.22.tar.gz
# cd mysql-5.0.22
# groupadd mysql
# useradd mysql -g mysql # ./configure --prefix=/usr/local/mysql
# make
# make install
# scripts/mysql_install_db --user=mysql
# cp support-files/my-medium.cnf /etc/my.cnf
# cp support-files/mysql.server /etc/init.d/mysqld # cd /usr/local
# chmod 750 mysql -R
# chgrp mysql mysql -R
# chown mysql mysql/var -R //注:我mysql目录下并没有var目录
# cd /usr/local/mysql/libexec
# cp mysqld mysqld.old
# strip mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on
# service mysqld start //我执行到这里,就会说mysql启动不了,我是在文本界面进行的。这里就出错了,后面我就没有必要进行了,
# netstat -atln
# ln -s /usr/local/mysql/bin/mysql /sbin/mysql
# ln -s /usr/local/mysql/bin/mysqladmin /sbin/mysqladmin
# mysqladmin -u root password "youpassword" #设置root帐户的密码
# mysql -uroot -p //到这里就会出现标题所说的错误,肯定是上面服务没有启动的问题。
# 输入你设置的密码
mysql>use mysql;
mysql>delete from user where password=""; #删除用于本机匿名连接的空密码帐号
mysql>flush privileges;
mysql>quit
问题如标题,我是按照以下做的 我首先把mysql-5.0.22.tar.gz 拷贝到/usr/local目录下
#cd /usr/local# tar zxvf mysql-5.0.22.tar.gz
# cd mysql-5.0.22
# groupadd mysql
# useradd mysql -g mysql # ./configure --prefix=/usr/local/mysql
# make
# make install
# scripts/mysql_install_db --user=mysql
# cp support-files/my-medium.cnf /etc/my.cnf
# cp support-files/mysql.server /etc/init.d/mysqld # cd /usr/local
# chmod 750 mysql -R
# chgrp mysql mysql -R
# chown mysql mysql/var -R //注:我mysql目录下并没有var目录
# cd /usr/local/mysql/libexec
# cp mysqld mysqld.old
# strip mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on
# service mysqld start //我执行到这里,就会说mysql启动不了,我是在文本界面进行的。这里就出错了,后面我就没有必要进行了,
# netstat -atln
# ln -s /usr/local/mysql/bin/mysql /sbin/mysql
# ln -s /usr/local/mysql/bin/mysqladmin /sbin/mysqladmin
# mysqladmin -u root password "youpassword" #设置root帐户的密码
# mysql -uroot -p //到这里就会出现标题所说的错误,肯定是上面服务没有启动的问题。
# 输入你设置的密码
mysql>use mysql;
mysql>delete from user where password=""; #删除用于本机匿名连接的空密码帐号
mysql>flush privileges;
mysql>quit
或者在MY.CNF里加上MYSQL.SOCK的位置。 socket = /tmp/mysql.sock