四月 28th, 2011

RedHat Linux 5.3 环境下安装MySQL 5.5指南

数据库问题解决方案, by 小哥.

下载安装包
MySQL-server-5.5.11-1.linux2.6.i386.rpm
MySQL-client-5.5.11-1.linux2.6.i386.rpm

安装后

修改密码
# usr/bin/mysqladmin -u root password ‘root123’

启动服务
# service mysqld start

登录mysql控制台
# mysql -u root -p

开启远程访问
mysql> grant select on 数据库.* to 用户名@登录主机 identified by “密码”
例如
mysql> grant all on *.* to root@’%’ identified by ‘root123’;

Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
解决方案
#ps -A|grep mysql
例如:
8047 pts/1 00:00:00 mysqld_safe
8124 pts/1 00:00:00 mysqld
8163 pts/1 00:00:00 mysql
8425 pts/2 00:00:00 mysql
# kill -9 1829
# kill -9 1876
# /etc/init.d/mysql restart
# mysql -u root -p

Back Top