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.server
find "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