ubuntu18.04-mysql安装

MySQl安装

###安装
sudo apt-get install mysql-server //服务端
sudo apt-get install mysql-client //客户端
sudo apt-get install libmysqlclient-dev //程序编译时链接的库

.进入到etc/mysql 目录下，查看debian.cnf文件中的初始随机生成的用户名和密码

这里是关键点，由于mysql5.7没有password字段，密码存储在authentication_string字段中，password()方法还能用
在mysql中执行下面语句修改密码

show databases;
use mysql;
update user set authentication_string=PASSWORD(“Abcd1234!”) where user=‘root’;
update user set plugin=“mysql_native_password”;
flush privileges;
quit;

4.修改完密码，需要重启mysql
/etc/init.d/mysql restart;

再次登录
mysql -u root -p 密码;
就ok了

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
把bind-address注释掉：#bind-address=…

###赋予用户权限
use mysql;
GRANT ALL ON . TO root@‘%’ IDENTIFIED BY ‘Abcd1234!’ WITH GRANT OPTION;
GRANT ALL ON . TO user@‘%’ IDENTIFIED BY ‘Abcd1234!’ WITH GRANT OPTION;
GRANT ALL ON . TO user@‘localhost’ IDENTIFIED BY ‘Abcd1234!’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

###创建数据表
CREATE DATABASE device_analyse_nolabel
use device_analyse_nolabel
set names utf8;
source /home/abc/abc.sql # 导入备份数据库