源码编译安装 MySQL 5.1.68
1、添加mysql用户和组
[root@lyq314 LNMP]#groupadd mysql
[root@lyq314 LNMP]#useradd -g mysql mysql
2、编译MySQL程序
[root@lyq314 LNMP]#tar -zxvf mysql-5.1.68.tar.gz
[root@lyq314 LNMP]#cd mysql-5.1.68
./configure --prefix=/usr/local/mysql5 --localstatedir=/usr/local/mysql5/data --without-debug--without-docs --without-geometry --without-ndb-debug --with-fast-mutexes --with-embedded-server --with-charset=utf8 --with-extra-charsets=complex --enable-thread-safe-client --with-readline --with-pthread --enable-profiling --enable-local-infile --enable-assembler --with-big-tables --with-plugins=federated,innobase
# make && make install
3、拷贝数据库的配置文件并做修改
cp -ar /usr/local/mysql5/share/mysql/my-medium.cnf /usr/local/mysql5/etc/my.cnf
4、初始化数据库
/usr/local/mysql5/bin/mysql_install_db --defaults-file=/usr/local/mysql5/etc/my.cnf --basedir=/usr/local/mysql5/ --datadir=/home/mysql/data --user=mysql
5、添加环境变量
echo "export PATH=$PATH:/usr/local/mysql5/bin" >> /etc/profile
[root@lyq314 ]# source /etc/profile
6、mysql的启动
/usr/local/mysql5/bin/mysqld_safe --defaults-file=/usr/local/mysql5/etc/my.cnf --datadir=/home/mysql/data --user=mysql &
7、查看mysql服务端口
# netstat -tunlp
[root@localhost etc]# netstat -nltp |grep 3306
tcp 00 0.0.0.0:3306 0.0.0.0:* LISTEN24752/mysqld
8、设置管理员密码
/usr/local/mysql5/bin/mysqladmin -u root password '1q2w3e4r'
9、登陆数据库进行测试
[root@lyq314 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.68-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database|
+--------------------+
| information_schema |
| mysql|
| test|
+--------------------+
3 rows in set (0.01 sec)
10、MySQL 的关闭
[root@lyq314 LNMP]# /usr/local/mysql5/bin/mysqladmin -uroot -p shutdown
Enter password:
[root@localhost LNMP]# 130711 02:46:23 mysqld_safe mysqld from pid file /home/mysql/data/mysql.pid ended