CentOS 6下编译安装mySQL5的过程

本篇内容介绍了“CentOS 6下编译安装mySQL5的过程”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！
一,准备工作
1,快速安装安装 CentOS6,安装时选择最小化安装.
2,安装编译时需要的库文件,这时可以选择做光盘yum
[root@admin share] # cd /media/
[root@admin media] # mkdir CentOS
[root@admin media] # moun免费主机域名t /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>“CentOS 6下编译安装mySQL5的过程”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注云技术网站，小编将为大家输出更多高质量的实用文章！

相关推荐: 怎么用脚本让mysql自动批量备份数据

这篇文章主要讲解了“怎么用脚本让mysql自动批量备份数据”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“怎么用脚本让mysql自动批量备份数据”吧！ 获取名称 #cat datanames.sh pass免费主…