安装
- yum -y install mysql-server mysql-devel (mysql服务器)
- yum install mysql (mysql客户端)
启动mysql
service mysqld start或者/etc/init.d/mysqld start
停止,重启mysql
service mysqld stop
service mysqld restart
创建root管理员:
mysqladmin -u root password root
登入
mysql -uroot -proot
root权限
- GRANT ALL PRIVILEGES ON . TO root@"%" IDENTIFIED BY “root”;
- flush privileges;
设置mysql的开机启动
- chkconfig --add mysqld
- chkconfig mysqld on
启动失败找原因
sudo less /var/log/mysqld.log
创建非root用户
-
创建用户名username的用户,可以任意IP登录,密码为password
CREATE USER ‘username’@’%’ IDENTIFIED BY ‘password’; -
创建用户名username的用户,固定IP登录,密码为password
CREATE USER ‘username’@‘192.168.1.91’ IDENTIFIED BY ‘password’; -
创建用户名username的用户,IP段登录,密码为password
CREATE USER ‘username’@‘192.168.1.%’ IDENTIFIED BY ‘password’;
给予权限
给予username访问database名是db_dev的所有表增删改查权限,限制IP段。
grant all privileges on db_dev.* to ‘username’@‘192.168.1.%’ identified by ‘password’ with grant option;
flush privileges;