1.如果本地连接mysql -uroot -p 报出Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'的错误,原因是，/var/lib/mysql 的访问权限问题。运行命令chown -R mysql:mysql /var/lib/mysql可解决,mysql的服务名为mysqld,所以
启动:service mysqld start;重启:service mysqld restart;停止:service mysqld stop;重载:service mysqld reload;
想新增用户:
>use mysql;//选择mysql数据表
>INSERT ('Host','User','Password') VALUES ('host','user',PASSWORD('password')) 即可添加账号为user 密码为password的账号 host可以是IP地址也可以是%通配符,PASSWORD()是一个加密函数,用以mysql内部来识别密码的.//增加用户
>GRANT ALL PRIVILEGES ON 库名.表名 TO 'mysql用户'@'mysql的host' IDENTIFIED BY 'mysql的密码' WITH GRANT OPTION;//添加权限 库名表名可以不用指定 *标识所有库和表
>FLUSH PRIVILEGES;//刷新权限(必须运行)
安装完后发现坑爹的事实,centos yum包里mysql是5.1的版本,目前使用起码应该是5.5,所以只能删了重装;安装5.5的方法是:
1.停止MYSQL运行以及卸载老版本
service mysqld stop #暂停MYSQL
yum remove mysql mysql-* #卸载老版本MYSQL
2.检查残余的mysql扩展并删除
yum list installed | grep mysql
yum remove mysql-libs
3.安装一些依赖环境
rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
rpm -Uvh http://mirrors.neusoft.edu.cn/epel/6/i386/epel-release-6-8.noarch.rpm
rpm -Uvh http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
rpm -Uvh http://dl.iuscommunity.org/pub/ius/stable/Redhat/6/x86_64/epel-release-6-5.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
4.安装mysql 5.5
yum --enablerepo=remi,remi-test info mysql mysql-server
yum --enablerepo=remi,remi-test install mysql mysql-server
5.启动和检查
mysql_upgrade -u root -p(如果进入数据库看不到mysql表,先运行/usr/bin/mysqld_safe --skip-grant-tables &启动mysql(不验证密码));