ubuntu mysql 相关

一、安装mysql

1. 下载：mysql-apt-config_0.8.17-1_all.deb 
   1. wget https://dev.mysql.com/get/mysql-apt-config_0.8.17-1_all.deb
2. 安装mysql-apt-config_0.8.17-1_all.deb
   1. dpkg -i mysql-apt-config_0.8.17-1_all.deb
3. 更新依赖
   1. sudo apt-get update
4. 安装mysql-server
   1. sudo apt-get install mysql-server

二、创建用户、修改密码、用户权限

1. 创建新用户

#对mysql8.0以下使用的
alter user 'username'@'localhost' identified by 'new password'
#对mysql8.0.26使用以下代码，不然会出错
#因为mysql8.0.26默认是caching_sha2_password，要修改成mysql_native_password
create user 'user_name'@'localhost' identified with mysql_native_password by 'newpassword';
#如果已经创建好的，修改方式如下
alter user 'user_name'@'localhost' identified with mysql_native_password by 'newpassword';

备注：username和new password 是自定义的。localhost代表是本地访问，%表示外网也可以访问。

   2. 查看：

mysql> use mysql
mysql> select t.host from user t where t.user='root';
+--------------+
|  host        |
+--------------+
|  localhost   |
+--------------+

 3.用户权限：

grant all privileges on database_name.* to username@localhost;
flush privileges;

也可以在vi /etc/mysql/mysql.conf.d/mysqld.cnf最后一行加上：skip-grant-tables
[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
log-error       = /var/log/mysql/error.log
skip-grant-tables

重启mysql:
service mysql restart