在Linux上安裝和配置MySQL可以分為幾個步驟。以下是一個基于Ubuntu的詳細指南:
sudo apt update
sudo apt install mysql-server -y
sudo mysql_secure_installation
sudo apt update
sudo apt install apt-transport-https ca-certificates curl software-properties-common
curl -fsSL https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb | sudo dpkg -i
sudo apt update
sudo apt install mysql-server
sudo systemctl start mysql
sudo systemctl enable mysql
sudo mysql_secure_installation
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address
為 0.0.0.0
以允許遠程連接。sudo systemctl restart mysql
sudo mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES;
sudo systemctl stop mysql
sudo mysqld_safe --skip-grant-tables &
mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';
FLUSH PRIVILEGES;
sudo mysql -u root -p
CREATE USER 'newuser'@'%' IDENTIFIED BY 'StrongPassword123!';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';
FLUSH PRIVILEGES;
sudo systemctl restart mysql
通過以上步驟,您應該能夠在Linux系統上成功安裝和配置MySQL。如果在安裝過程中遇到任何問題,可以參考官方文檔或尋求社區幫助。