lnmp无法连接mysql_LNMP相关问题——PHP无法连接MySQL之一

尝试解决步骤：一、重新编译MySQL(1)使用以下参数重新编译MySQLcmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DMYSQL_DATADIR=/data1/mysql_db -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DWITH_READLINE=ON -DWITH_SSL=system -DWITH_DEBUG=0 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DINSTALL_LAYOUT=STANDALONE -DENABLED_LOCAL_INFILE=1 -DENABLED_PROFILING=1 -DMYSQL_MAINTAINER_MODE=0 -DWITH_EMBEDDED_SERVER=1 -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql编译完成后，启动mysqld服务会出现以下错误：120726 11:32:27 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown120726 11:32:27 [Note] Event Scheduler: Purging the queue. 0 events120726 11:32:27  InnoDB: Starting shutdown...120726 11:32:27  InnoDB: Shutdown completed; log sequence number 1595675120726 11:32:27 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete120726 11:32:27 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended120726 11:32:52 mysqld_safe Starting mysqld daemon with databases from /data1/mysql_db120726 11:32:52 [ERROR] COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'120726 11:32:52 [ERROR] Aborting120726 11:32:52 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete120726 11:32:52 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended是字符集问题，于是修改my.cnf文件，在[mysqld]下参数：character-set-server = utf8之后启动mysqld服务成功。(2)尝试用下面PHP脚本连接MySQL数据库