在CentOS 6.5上安裝MySQL

来源：互联网发布：access与数据透视表编辑：程序博客网时间：2024/05/18 03:21

安装说明

安装环境：CentOS-6.3

安装方式：yum install

裝完後

chgrp -R mysql /var/lib/mysql
chmod -R 770 /var/lib/mysql

然後打開服務

service mysqld start

改密碼

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h hostname password 'new-password'

reset root 密碼

/etc/init.d/mysqld stop

mysqld_safe --skip-grant-tables &

mysql -u root -p

mysql> use mysql;
mysql> update user set password=PASSWORD("新root密碼") where User='root';
mysql> flush privileges;
mysql> quit

/etc/init.d/mysqld stop

/etc/init.d/mysqld start

新增mysql.user host

mysql> CREATE USER 'root'@'192.168.1.1' IDENTIFIED BY '設定此host的password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.1' WITH GRANT OPTION;

新增mysql.user host '%' : 允許所有內外部連線

mysql> CREATE USER 'root'@'%' IDENTIFIED BY '設定此host的password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

刪除host

drop user 'root'@'localhost';

登入root 加 host

mysql -u root -h hostname -p

原文链接

0 0