Linux + Apache + Mysql + Python-maozidong

喜旎果

　　cd /etc/rc.d/init.d
　　chkconfig --add mysqld
　　5 修改启动脚本
　　vi /etc/init.d/mysqld
　　6. 启动和停止mysql
　　service mysqld start/stop
　　7.设置mysql的root密码
　　/usr/local/lamp/mysql/bin/mysqladmin -uroot -p passwd 'mysqlmima'
　　到此mysql-5.5.16 就安装完毕。记录下希望对大家有帮助。
　　问题：
　　[root@fedora scripts]# /etc/rc.d/init.d/mysqld status
　　MySQL is running but PID file could not be found           [FAILED]
　　[root@fedora scripts]# service mysqld start
　　Starting MySQL.The server quit without updating PID file (/home/han/www/mysql/data/fedora.pid).       [FAILED]
原来没有对表进行初始化#cd /usr/local/lamp/mysql#chown -R mysql .   (最后空不格有一个点)[root@fedora mysql]# su mysql[mysql@fedora mysql]$ scripts/mysql_install_db[mysql@fedora mysql]$ /usr/local/lamp/mysql/bin/mysqld_safe --user=mysql &FATAL ERROR: Could not find ./bin/my_print_defaults回到上scripts的上一级目录就没这问题了 MySQL server PID file could not be found![FAILED]#ps aux|grep mysq*　　Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
　　[mysql@fedora mysql]$ ./scripts/mysql_install_db
　　[mysql@fedora mysql]$ ./bin/mysqld_safe --user=mysql &
[mysql@fedora mysql]$ ./bin/mysql_upgrade [mysql@fedora mysql]$ ./scripts/mysql_install_db --ldata=/home/han/www/mysql/data　　unsupported storage engine: InnoDB
　　原因：MySQL5.5.8 GA默认引擎为InnoDB，而配置文件（my.cnf）中设置了skip-innodb
　　解决：在配置文件（my.cnf）中设置default-storage-engine=MyISAM
　　./mysql-bin.index' not found (Errcode: 13)
　　原来mysql-bin.index没有写权限　　chmod 666 mysql-bin.index
mysqld: Table ‘mysql.plugin’ doesn’t exist
　　mysql$ mysqld –skip-grant &
　　./bin/mysql_upgrade -d /home/you/www/mysql/data
　　Table 'mysql.plugin' doesn't exist
　　130107 21:20:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.