centos操作系统中mysql的安装与配置

来源：互联网发布：淘宝红包套现被处罚编辑：程序博客网时间：2024/05/17 06:50

1. 主要下载mysql (mysql-client)，mysql-server，mysql-devel，mysql-libs以及一些链接库(yum下载)。

2. 首次登录mysql配置文件/etc/my.cnf，在配置文件中添加一行skip-grant-tables，并重启mysql服务。

/etc/init.d/mysqld restart

mysql (无需密码)

->use mysql;

->update user set password=password('123456') where user='root';(更改密码为123456)

->flush privileges;(密码更新刷新)

->quit

/etc/init.d/mysqld restart

3. mysql配置外部IP访问。

(修改表方法)

mysql -uroot -p123456 -h127.0.0.1

->use mysql;

->select user,host from user;

->update user set host='%' where user='root';

->select user,host from user;

->flush privileges;

->quit

(授权用户方法)

mysql -uroot -p123456 -h127.0.0.1

->use mysql;

->select user,host from user;

->GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

->select user,host from user;

->flush privileges;

->quit

或者对特定IP开启访问权限

mysql -uroot -p123456 -h127.0.0.1

->use mysql;

->select user,host from user;

->GRANT ALL PRIVILEGES ON *.* TO 'root'@'xx.xx.xx.xx' IDENTIFIED BY '123456' WITH GRANT OPTION;

->select user,host from user;

->flush privileges;

->quit

阅读全文

0 0