配置mysql

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(不验证密码));

转载于:https://www.cnblogs.com/tudou1223/p/4904198.html