deepin20.1系统安装MySQL8.0.23(超详细的MySQL8安装教程)

下载MySQL-8.0.23
点击下载：mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz

mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz

解压MySQL的安装包到一个目录（这里我选择的是：/usr/local）

sudo tar -Jxv -f /home/×××shanlin/Downloads/mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

创建软链接（操作方便：可以认为是给mysql-8.0.23-linux-glibc2.12-x86_64目录起了一个别名叫mysql）

sudo ln -s /usr/local/mysql-8.0.23-linux-glibc2.12-x86_64 mysql

sudo mkdir -p /data/mysql/datasudo mkdir -p /var/run/mysqld

sudo groupadd mysqlsudo useradd -r -g mysql mysql

sudo chown mysql:mysql -R /data/mysql/datasudo chown mysql:mysql -R /var/run/mysqld

[mysqld]bind-address=0.0.0.0port=3306user=mysqlbasedir=/usr/local/mysqldatadir=/data/mysql/datasocket=/var/run/mysqld/mysqld.socklog-error=/data/mysql/data/mysql.errpid-file=/data/mysql/data/mysql.pidcharacter_set_server=utf8mb4symbolic-links=0explicit_defaults_for_timestamp=truedefault_authentication_plugin=mysql_native_password#解决Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)错误[client]port=3306socket=/var/run/mysqld/mysqld.sock

#mysql MYSQL_HOME=/usr/local/mysqlPATH=$PATH:$MYSQL_HOME/binexport PATH MYSQL_HOME

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

开启MySQL服务

sudo /usr/local/mysql/support-files/mysql.server start

sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

sudo ln -s /usr/local/mysql/bin/mysql /usr/bin

mysql -u root -p

alter user 'root'@'localhost' identified by '123456';

更多相关文章

随机推荐