CentOS 6下编译安装mySQL5_MySQL
一,准备工作
1,快速安装安装 CentOS6,安装时选择最小化安装.
2,安装mysql编译时需要的库文件,这时可以选择做光盘yum
[root@admin share] # cd /media/
[root@admin media] # mkdir CentOS
[root@admin media] # mount /dev/cdrom /media/CentOS
[root@admin media]# cd /etc/yum.repos.d/
[root@admin yum.repos.d] # mv CentOS-Base.repo CentOS-Base.repo.bak
[root@admin yum.repos.d] # mv CentOS-Debuginfo.repo CentOS-Debuginfo.repo.bak
至此,用光盘做的yum就可用了;
[root@admin ~]#yum --enablerepo=c6-media install ncurses* gcc* perl* -y
3,准备好安装包. (这里以 mysql-5.0.56.tar.gz举例)
4,添加mysql 用户
[root@admin ~]#groupadd mysql
[root@admin ~]#useradd -g mysql mysql -s /bin/nologin
二,正式安装
1. [root@admin software]#tar zxvf mysql-5.0.56.tar.gz
2. [root@admin software]# cd mysql-5.0.56
3. [root@admin mysql-5.0.56]# ./configure --prefix=/usr/local/mysql --localstatedir=/data/mysql --enable-assembler -- enable-static --with-mysqld-user=mysql --with-big-tables --enable-thread-safe-client -- enable-local-infile --with-charset-utf8 --with-extra-charsets=all
4. [root@admin mysql-5.0.56]# make && make install
5. [root@admin mysql-5.0.56]# cp support-files/my-medium.cnf /etc/my.cnf
6. [root@adim share]# cd /usr/local/mysql/
7. [root@admin mysql]# bin/mysql_install_db --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/local/mysql/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
8. [root@admin mysql]# chown -R mysql.mysql /data/mysql/
9. [root@admin mysql]# share/mysql/mysql.server start
Starting MySQL SUCCESS! #--------------> 看到如此,便知道安装成功了.
10. [root@admin mysql]# netstat -tunlp | grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 13193/mysqld
三. 后绪工作
1.[root@admin ~]# ln -s /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld
2.[root@admin ~]# ln -s /usr/local/mysql/bin/mysql /usr/sbin/mysql
3.[root@admin ~]# ln -s /usr/local/mysql/bin/mysqladmin /usr/sbin/mysqladmin
4.[root@admin ~]# ln -s /usr/local/mysql/bin/mysqldump /usr/sbin/mysqldump
5.[root@admin ~]# mysql -uroot -p
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 2
Server version: 5.0.56-log Source distribution
Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
mysql>
本文出自 “OpenSource滴天空” 博客
bitsCN.com上一篇: 什么是数据注入变量?它的使用场景是什么?
下一篇: JS使用正则控制用户输入银行卡号及格式化
推荐阅读
-
CentOS 7.x编译安装Nginx1.10.3+MySQL5.7.16+PHP5.2 5.3 5.4 5.5 5.6 7.0 7.1多版本全能环境
-
详解Centos7.2编译安装zabbix3.2(详细步骤)
-
Centos7.2 编译安装PHP7.0.2的步骤
-
Gearman::XS在Centos下的编译安装方法
-
centos编译安装mysql 5.6及安装多个mysql实例详解
-
详解Lamp环境搭建Linux CentOS6.5编译安装mysql5.6
-
CentOS 6.5上编译安装Apache服务器的方法(最小化安装)
-
CentOS6.5 编译安装lnmp环境
-
CentOS 6.4系统下编译安装LNMP和配置PHP环境具体步骤
-
Centos7.2 编译安装方式搭建 phpMyAdmin