CentOS 6.6 MySQL 5.5.32 绿色版安装配置

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了CentOS 6.6 MySQL 5.5.32 绿色版安装配置，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3853字，纯文字阅读大概需要6分钟。

内容图文

绿色版安装配置

 

1. 基本信息

系统版本：CentOS 6.6

MySQL版本：5.5.32 绿色版

 

1. 初始化MySQL，出现黄色部分两个OK，表示初始化正确

[root@lnmp02 tools]# useradd -s/sbin/nologin -M mysql

[root@lnmp02 tools]# tar zxvfmysql-5.5.32-linux2.6-x86_64.tar.gz

[root@lnmp02 tools]# mvmysql-5.5.32-linux2.6-x86_64  /application/mysql-5.5.32

[root@lnmp02 tools]# ln -s/application/mysql-5.5.32  /application/mysql

[root@lnmp02 application]#/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/--datadir=/application/mysql/data/ --user=mysql

Installing MySQL system tables...

OK

Filling help tables...

OK

 

To start mysqld at boot timeyou have to copy

support-files/mysql.server tothe right place for your system

 

PLEASE REMEMBER TO SET APASSWORD FOR THE MySQL root USER !

To do so, start the server,then issue the following commands:

 

/application/mysql//bin/mysqladmin-u root password ‘new-password‘

/application/mysql//bin/mysqladmin-u root -h lnmp02 password ‘new-password‘

 

Alternatively you can run:

/application/mysql//bin/mysql_secure_installation

 

which will also give you theoption of removing the test

databases and anonymous usercreated by default.  This is

strongly recommended forproduction servers.

 

See the manual for moreinstructions.

 

You can start the MySQL daemonwith:

cd /application/mysql/ ;/application/mysql//bin/mysqld_safe &

 

You can test the MySQL daemonwith mysql-test-run.pl

cd/application/mysql//mysql-test ; perl mysql-test-run.pl

 

Please report any problems withthe /application/mysql//scripts/mysqlbug script!

 

1. 改变/application/mysql所属主和组，cp配置文件，改变MySQL启动脚本里的路径

[root@lnmp02 ~]# chown -Rmysql.mysql /application/mysql/

[root@lnmp02 ~]# cp /application/mysql/support-files/my-small.cnf /etc/my.cnf

[root@lnmp02 ~]# sed -i‘s#/usr/local/mysql#/application/mysql#g‘ /application/mysql/bin/mysqld_safe     ###修改脚本里的安装路径

[root@lnmp02 ~]#/application/mysql/bin/mysqld_safe &  ###以后台进程方式启动MySQL

 

1. 查看MySQL是否正常启动

[root@lnmp02 ~]# lsof -i:3306

[root@lnmp02 ~]# netstat-tulpn|grep 3306

[root@lnmp02 ~]# ps -ef|grepmysql

 

1. 配置环境变量

[root@lnmp02 ~]# echo"PATH=/application/mysql/bin:$PATH" >>/etc/profile

[root@lnmp02 ~]# source/etc/profile

[root@lnmp02 ~]# which mysql    ###确定是否是绿色版的MySQL而不是yum安装的MySQL

/application/mysql/bin/mysql

 

1. 登陆MySQL

[root@lnmp02 ~]# mysql

Welcome to the MySQLmonitor.  Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.5.32 MySQLCommunity Server (GPL)

 

Copyright (c) 2000, 2013,Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registeredtrademark of Oracle Corporation and/or its

affiliates. Other names may betrademarks of their respective

owners.

 

Type ‘help;‘ or ‘\h‘ for help.Type ‘\c‘ to clear the current input statement.

 

mysql>

 

1. 配置传统方式启动MySQL

[root@lnmp02 ~]# cp/application/mysql/support-files/mysql.server /etc/init.d/mysqld

[root@lnmp02 ~]# sed -i‘s#/usr/local/mysql#/application/mysql#g‘ /etc/init.d/mysqld  ##修改mysql安装路径

[root@lnmp02 ~]# killall mysqld   ###杀死之前启动的mysql进程

[root@lnmp02 ~]# lsof -i:3306    ###确认是否已杀死mysql进程

[root@lnmp02 ~]#/etc/init.d/mysqld start   ###以传统方式重新启动mysql进程

 

1. 设置mysql管理员密码，默认管理员是root用户

[root@lnmp02 ~]# mysqladmin-uroot password "123456"

[root@lnmp02 ~]# mysql -uroot-p123456   ###登陆mysql，注意，-p和密码之间不能有空格

[root@lnmp02 ~]# mysqladmin-uroot -p123456 password "wangning" ###更改密码

 

1. 查看错误日志

[root@lnmp02 ~]# cat  /application/mysql/data/lnmp02.err    ###该错误日志文件是以主机名加.err后缀命名的

本文出自 “飞奔的骆驼” 博客，请务必保留此出处http://wn2100.blog.51cto.com/9915310/1941597

CentOS 6.6 MySQL 5.5.32 绿色版安装配置

标签：mysql 5.5.32 绿色版安装配置   linux   centos 6.6   

本文系统来源：http://wn2100.blog.51cto.com/9915310/1941597

内容总结

以上是互联网集市为您收集整理的CentOS 6.6 MySQL 5.5.32 绿色版安装配置全部内容，希望文章能够帮你解决CentOS 6.6 MySQL 5.5.32 绿色版安装配置所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---