linux下面源代码安装MYSQL

用 root 用户执行以下步骤：

groupadd mysql

useradd -g mysql mysql

cd /usr/local

tar zxvf /root/mysql-5.0.22.tar.gz # MySQL 源代码包的绝对路径

cd mysql-5.0.22

./configure --enable-thread-safe-client --with-unix-socket --with-mysqld-user=mysql --with-charset=gbk --prefix=/usr/local/mysql

make # 这一步时间较长

make WITH_XCHARSET=gbk,bg2312 install

scripts/mysql_install_db

chown -R root /usr/local/mysql

chown -R mysql /usr/local/mysql/var

chgrp -R mysql /usr/local/mysql

cp support-files/my-medium.cnf /etc/my.cnf

/usr/local/mysql/bin/mysqld_safe & # 启动 MySQL

/usr/local/mysql/bin/mysqladmin -u root password 'new-password' # 修改 MySQL root 用户口令

 
   使用如下命令登录MYSQL:

 

 /usr/local/mysql/bin/mysql -uroot -p

 

   停止服务器：

 

mysqladmin shutdown
是mysqladmin而不是mysqldump