ubuntu下安装mysql

linux 版本mysql下载地址 https://downloads.mysql.com/archives/community/

scp -r /home/soft/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz root@0.1.1.***:/home/soft/

tar -zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
mkdir -p /usr/local/mysql
mv mysql-8.0.11-linux-glibc2.12-x86_64/* /usr/local/mysql

vim /etc/my.cnf

[client]
port=3306
socket=/tmp/mysql/mysql.sock

[mysqld]
port=3306
user=mysql
socket=/tmp/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-error=/usr/local/mysql/data/error.log
pid-file=/usr/local/mysql/data/mysql.pid
tmpdir=/tmp

mkdir /tmp/mysql
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /tmp/mysql

cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

#启动mysql服务
cd /usr/local/mysql/support-files
./mysql.server start

cat /usr/local/mysql/data/error.log
root@localhost: lWiy)KoQF05;
root@localhost: r.D?6:NRuT>>

连接
cd /usr/local/mysql/bin
./mysql -uroot -p'lWiy)KoQF05;'
./mysql -uroot -p'r.D?6:NRuT>>'

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

use mysql;
-- select user,host from user;

update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;

ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;
quit

./mysql -uroot -p'*'

远程连接 ubuntu下密码有括号等特殊字符，需要用单引号引起来。windows远程访问如果密码用单引号引起来，则会访问不到。
mysql -h* -uroot -P3306 -p*
mysql -h* -uroot -P3306 -p*