安装MySQL的yum源:
cd /tmp/ //切换到tmp目录
wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm //下载源
yum localinstall -y mysql57-community-release-el6-9.noarch.rpm //安装源
安装MySQL:
yum search mysql
yum install mysql-community-server.x86_64
修改root密码:
开启服务:
service mysqld start
查看默认root密码:
mysql安装成功后创建的超级用户'root'@'localhost'的密码会被存储在/var/log/mysqld.log,可以使用如下命令查看密码
cat /var/log/mysqld.log | grep password
mysql -uroot -p
回车输入默认root密码
进入mysql后无论输入什么都会提示:You must reset your password using ......
这是由于使用的使默认密码,需要设置自己的密码后才可以
SET PASSWORD = PASSWORD('your new password');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;
注:如果想要设置简单密码,还需要进行如下操作
修改密码策略:
set global validate_password_policy=0;
set global validate_password_length=0;
开启远程连接:
登陆mysql:
use mysql;
update user set host='%' where Host="localhost" and User="root";
flush privileges;
此时还是不能进行远程登陆:需要配置防火墙:
firewall-cmd --add-service=mysql
firewall-cmd --add-port=3306/tcp
service firewalld restart
测试连接:
在win下的命令窗口下:
开启genelog:
在general log模式开启过程中,所有对数据库的操作都将被记录 general.log 文件
set global general_log_file="/tmp/general.log";
set global general_log=on;
关闭genelog:
set global general_log=off;
数据库的一些操作:
新建用户:
CREATE USER 'test'@'%' IDENTIFIED BY '123456';
赋予权限:
//所有权限
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
//select,insert,update,delete权限
GRANT select,insert,update,delete ON *.* TO 'test'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
//使配置生效
FLUSH PRIVILEGES;
收回权限:
REVOKE ALL PRIVILEGES ON *.* FROM test;
FLUSH PRIVILEGES;
忘记root 密码:
在 /etc/my.cnf 加入 skip-grant-tables可以免密码登陆mysql
use mysql;
update user set authentication_string=password('456789') where user='root';