在LAMP(Linux, Apache, MySQL, PHP)环境中配置MySQL是一个相对直接的过程,但需要确保每一步都正确执行。以下是详细的步骤:
sudo apt-get update
sudo apt-get install mysql-server
wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
tar -xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.24-linux-glibc2.12-x86_64 /usr/local/mysql-5.7.24
cd /usr/local/mysql-5.7.24
./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.7.24 --datadir=/usr/local/mysql-5.7.24/data/
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /usr/local/mysql-5.7.24
chgrp -R mysql /usr/local/mysql-5.7.24
cp -a ./support-files/mysql.server /etc/init.d/mysqld
/etc/profile
文件,添加以下行:export PATH=$PATH:/usr/local/mysql-5.7.24/bin
source /etc/profile
/etc/my.cnf
,确保以下配置正确:[mysqld]
basedir=/usr/local/mysql-5.7.24
datadir=/usr/local/mysql-5.7.24/data
port=3306
socket=/var/lib/mysql/mysql.sock
chkconfig --add mysqld
chkconfig mysqld on
service mysqld start
ps -ef grep mysqld
netstat -lnp | grep 3306
mysql -u root -p
UPDATE mysql.user SET password='your_new_password' WHERE User='root';
FLUSH PRIVILEGES;
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload
sudo apt-get install php-mysql
yum install php-mysqlnd
service apache2 restart
通过以上步骤,您应该能够在LAMP环境中成功配置MySQL。如果在安装过程中遇到任何问题,请检查每一步的输出并确保所有依赖项都已正确安装。