日期:2014-05-16  浏览次数:20679 次

mysql在linux下安装
Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

解决办法 在运行初始化权限表的时候使用增加参数--datadir ,命令格式为:
shell> ..../mysql_install_db --user=mysql --datadir=/usr/local/mysql/var
------------------------------------
1.下载mysql-5.1.49.tar.gz
2.解压缩到/u/mysql
3.cd /u/mysql
4../configure --with-named-curses-libs=/lib/libncursesw.so.5
5. make&make install
5.mysql_install_db
6. 运行mysqld_safe

fedora12下mysql安装
-------------------------------
#yum install mysql mysql-server
#chkconfig --levels 235 mysqld on
#mysql_install_db
#/etc/init.d/mysqld start

安装apache2
--------------------------------

yum install httpd
chkconfig --levels 235 httpd on
/etc/init.d/httpd start

安装php
yum install php
/etc/init.d/httpd restart


-------------mysql目录分布---------------------------------------------------
1、数据库目录
  /var/lib/mysql/

  2、配置文件
  /usr/share/mysql(mysql.server命令及配置文件)

  3、相关命令
  /usr/bin(mysqladmin mysqldump等命令)

  4、启动脚本
  /etc/rc.d/init.d/(启动脚本文件mysql的目录)

----------------------修改密码---------------------------------------------
mysqladmin -u root password 'new-password'