MySQL安装过程中出现的问题(四)
vmware-root vmware.txt
[root@localhost tmp]# cd /usr/local/mysql/
[root@localhost mysql]# pwd
/usr/local/mysql
[root@localhost mysql]# chown -R root:mysql . 忽然想起来了没有设置权限呢，开始设置权限
[root@localhost mysql]# ll
total 36
drwxr-xr-x 2 root mysql 4096 Nov 28 21:51 bin
drwxr-xr-x 3 root mysql 4096 Nov 28 21:50 include
drwxr-xr-x 2 root mysql 4096 Nov 28 21:50 info
drwxr-xr-x 3 root mysql 4096 Nov 28 21:50 lib
drwxr-xr-x 2 root mysql 4096 Nov 28 21:51 libexec
drwxr-xr-x 4 root mysql 4096 Nov 28 21:50 man
drwxr-xr-x 8 root mysql 4096 Nov 28 21:51 mysql-test
drwxr-xr-x 3 root mysql 4096 Nov 28 21:50 share
drwxr-xr-x 5 root mysql 4096 Nov 28 21:50 sql-bench
[root@localhost mysql]# chown -R mysql /var/lib/mysql
[root@localhost mysql]# cp share/mysql/my-huge.cnf /etc/my.cnf
[root@localhost mysql]# cp share/mysql/mysql.server /etc/rc.d/init.d/mysqld
[root@localhost mysql]# chmod 755 /etc/rc.d/init.d/mysqld
[root@localhost mysql]# chkconfig --add mysqld
[root@localhost mysql]# chkconfig --level 345 mysqld on
=======error========
[root@localhost mysql]# mysqladmin -u root password 'uplooking'
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! 又是上边一样的错误
[root@localhost mysql]# bin/mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
[root@localhost mysql]# /etc/rc.d/init.d/mysqld status
MySQL is not running, but lock exists [FAILED] 这里说的是没有运行着mysql，但是还在锁定。这时候我看到了下边那篇文章，重新检查了一遍权限，
[root@localhost mysql]# chown -R mysql:mysql /var/lib/mysql 在这里，我原来设置的时候这个组没有设置，只写了chown -R mysql /var/lib/mysql，分组被我忽略掉了，哎，折腾这么长时间。
[root@localhost mysql]# /etc/rc.d/init.d/mysqld start 从这里，mysql启动正常了
Starting MySQL [ OK ]
[root@localhost mysql]# /etc/rc.d/init.d/mysqld stop
Shutting down MySQL [ OK ]
[root@localhost mysql]#
[root@localhost mysql]# mysqladmin -u root password 'uplooking' 这里是说服务器没有启动
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
[root@localhost mysql]# /etc/rc.d/init.d/mysqld start 启动服务器
Starting MySQL [ OK ]
[root@localhost mysql]# mysqladmin -u root password 'uplooking' 添加root密码
[root@localhost mysql]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@localhost mysql]# mysql -u root -p 用root密码登陆，测试。
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.56-Comsenz-log Source
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> quit
Bye
[root@localhost mysql]# service mysqld restart
Shutting down MySQL [ OK ]
Starting MySQL [ OK ]
[root@localhost mysql]#
====权限的验证测试====
[root@localhost mysql]# cd /tmp
[root@localhost tmp]# mkd