centos mysql 5.6.19_Centos5.8 安装 MySQL5.6.19

查看已经安装的mysql:

sudo yum list installed |grep mysql

删除

sudo yum remove mysql

安装

sudo rpm -ivh MySQL-server-5.6.19-1.rhel5.x86_64.rpm

会发现mysql已经被添加到/etc/init.d/

查看服务状态

sudo /sbin/service mysql status

启动服务

sudo /sbin/service mysql start

ps查看, 服务运行在mysql用户下,

检查启动参数

sudo /sbin/chkconfig –list mysql

mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off

已经添加到系统自启动

my.cnf在 /usr 下, 添加以下基本参数

join_buffer_size = 64M

sort_buffer_size = 4M

read_rnd_buffer_size = 4M

key_buffer_size=16M

max_allowed_packet=16M

修改默认端口会遇到selinux的权限问题, 具体可以看

https://blogs.oracle.com/jsmyth/entry/selinux_and_mysql

可以通过 sudo /usr/sbin/semanage port -l 查看当前的端口状态

semanage port -a -t mysqld_port_t -p tcp 6033

就可以指定其他端口了

#########

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !

You will find that password in ‘/home/milton/.mysql_secret’.

You must change that password on your first connect,

no other statement but ‘SET PASSWORD’ will be accepted.

See the manual for the semantics of the ‘password expired’ flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test database.

This is strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

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

New default config file was created as /usr/my.cnf and

will be used by default by the server when you start it.

You may edit this file to change server settings

#########

编译安装

需要预先安装ncurses-devel, 否则会报错”Curses library not found”.

sudo yum install ncurses-devel

cmake需要用root权限运行:

sudo cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql

-DMYSQL_DATADIR=/opt/mysql/data -DWITH_INNOBASE_STORAGE_ENGINE=1

-DMYSQL_TCP_PORT=6033 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8

-DDEFAULT_COLLATION=utf8_general_ci

添加用户和组

shell> sudo groupadd mysql

shell> sudo useradd -r -g mysql mysql

# cd /opt/mysql

# sudo chown -R mysql .

# sudo chgrp -R mysql .

安装测试数据

# sudo scripts/mysql_install_db –user=mysql

显示如下:

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:

./bin/mysqladmin -u root password ‘new-password’

./bin/mysqladmin -u root -h ML-M0 password ‘new-password’

Alternatively you can run:

./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 . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

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

New default config file was created as ./my.cnf and

will be used by default by the server when you start it.

You may edit this file to change server settings

再修改用户

# sudo chown -R root .

# sudo chown -R mysql data

启动服务

# sudo bin/mysqld_safe –user=mysql &

添加到系统启动

# sudo cp support-files/mysql.server /etc/rc.d/init.d/mysqld

# sudo chkconfig --add mysqld

Centos 6.3 压缩包安装MySQL5.6.2x

# cd /opt/mysql

#tar zxvf mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz

#ln -s mysql-advanced-5.6.23-linux-glibc2.5-x86_64 mysql

# cd mysql

#--- install &init

#sudo chown -R mysql:mysql .

#sudo ./scripts/mysql_install_db --user=mysql

#---start the server (这边加 --user=mysql 的时候不成功, 后来不加这个才正常启动的)

#sudo ./bin/mysqld_safe &[1] 3492[root@racnote1 mysql]#150324 16:33:40 mysqld_safe Logging to '/usr/local/mysql/data/racnote1.err'.150324 16:33:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

Ctrl+C

#---add it to the service

#sudo cp support-files/mysql.server /etc/init.d/mysql.server

#sudo vi /etc/init.d/mysql.serverfind "basedir=", add the path to mysql installation, e.g. "basedir=/opt/mysql/mysql"#sudo chkconfig --list

#sudo chkconfig --add mysql.server

#sudo chkconfig --list

#---initialize the root password

#sudo ./bin/mysql_secure_installation

#--- link the mysql executable to /usr/bin

# cd/usr/local/bin

#sudo ln -s /opt/mysql/mysql/bin/mysql mysql