sudo apt-get install mysql-server mysql-client
启动时出错:
Failed to start mysqld.service: Unit mysqld.service failed to load: No such file or directory.
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)
解决办法:
# systemctl enable mysql.service
mysq基本操作
1.启动: service mysql status
2.登录(帐号密码都为root):mysql -uroot -proot
3.退出当前mysql:exit
4.关闭mysql服务:service mysql stop
5.显示所有数据库:show databases;
6.建立数据库:create database test;
7.连接数据库:use test;
8.建立表:create table student ( id integer primary key, name varchar(30) );
9.插入行:insert into student values(1, 'zsl', 18, 'woman');
10.select * from student;
11.修改密码:mysql -r root -p root password newpassword;