CentOS系统下安装mysql数据库
1.下载安装mysql
服务器:
yum install mysql-server -y
客户端:yum install mysql-devel -y
2.启动服务
service mysqld start
3.创建用户密码
mysqladmin -u [用户名] password [密码]
4.使用
-1
mysql -u[用户名] -p[密码]
-2show databases;
-3use mysql;
-4show tables;
-5select host , password from user;
- host:能够访问的用户
-6
delete from user where password=" ";
-7
update user set host="%";
-8 更新权限:flush privileges;
-9 Linux下确保关闭防火墙service iptables stop
-10 可以在外部环境使用navicat连接数据库
退出
- 退出MySQL:
quit
- 关闭mysql服务:
service mysqld sotp