CentOS6下编译安装mySQL5的过程

本篇内容介绍了“CentOS 6下编译安装MySQL5的过程”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

站在用户的角度思考问题，与客户深入沟通，找到穆棱网站设计与穆棱网站推广的解决方案，凭借多年的经验，让设计与互联网技术结合，创造个性化、用户体验好的作品，建站类型包括：做网站、成都做网站、企业官网、英文网站、手机端网站、网站推广、空间域名、虚拟空间、企业邮箱。业务覆盖穆棱地区。

一,准备工作
     1,快速安装安装 CentOS6,安装时选择最小化安装.
     2,安装编译时需要的库文件,这时可以选择做光盘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>

“CentOS 6下编译安装mySQL5的过程”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联网站，小编将为大家输出更多高质量的实用文章！

分享标题：CentOS6下编译安装mySQL5的过程
标题URL：https://www.cdcxhl.com/article48/ppehhp.html

成都网站建设公司_创新互联，为您提供手机网站建设、关键词优化、外贸建站、网页设计公司、网站建设、品牌网站制作

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源：创新互联

猜你还喜欢下面的内容