Linux centos6.5 安装mysql 以及简要操作书册

最新推荐文章于 2019-06-22 16:39:14 发布

程序员小陶

最新推荐文章于 2019-06-22 16:39:14 发布

阅读量150

点赞数

分类专栏：大数据探索文章标签： mysql

本文链接：https://blog.csdn.net/qq_31975963/article/details/84113089

版权

29 篇文章 1 订阅

订阅专栏

sudo rpm -qa | grep mysql

sudo rpm -e --nodeps mysql-libs-5.1.66-2.el6_3.x86_64
卸载完成之后再查看一下，确保卸载完成

sudo yum -y install mysql-server (如果yum源有问题，那就更换一下yum源即可)

sudo rpm -qa | grep mysql
mysql-server-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64
mysql-libs-5.1.73-8.el6_8.x86_64

chkconfig | grep mysql

启动：sudo service mysqld start
设置登陆密码：mysqladmin -u root password ‘123456’
设置开机启动：sudo chkconfig mysqld on

mysql -uroot -p123456

mysql> select User,Host,Password from user;

mysql> grant all privileges on *.* to 'xningge'@'%' identified by 'WN@950421' with grant option;

mysql> delete from user where user='root' and host='127.0.0.1';

mysql> flush privileges;

service mysqld restart

qiut+;或者crtl+C

授权：grant all privileges on *.* to 'root'@'192.168.111.1' identified by '123456' with grant option;

刷新信息
mysql> flush privileges;

关注