Ubuntu安装mysql

命令如下

apt update &&  apt install mysql-server -y

mkdir -p /export/Data/mysql  && cp -R /var/lib/mysql/* /export/Data/mysql/ && chown -R mysql:mysql /export/Data/mysql


# passwd root
mysql -u root <<EOF
ALTER USER 'root'@'localhost' IDENTIFIED BY '1433223';
FLUSH PRIVILEGES;
EOF

# create remote user
mysql -u root <<EOF
CREATE USER 'user'@'%' IDENTIFIED BY '1433223';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EOF

可添加到进程托管

[program:mysql]
user=mysql
command=/usr/bin/mysqld --datadir=/export/Data/mysql
autorestart=true
startsecs=10
redirect_stderr=true
stdout_logfile=/var/log/mysql.out.log
stderr_logfile=/var/log/mysql.err.log
logfile_maxbytes=50MB
logfile_backups=2

管理面板可选: dbgate