mariadb-10.0.21 > cd /usr/local/mysql/
root@nginx1 /usr/local/mysql > chown -R mysql:mysql ./*
root@nginx1 /usr/local/mysql >?
root@nginx1 /usr/local/mysql > scripts/mysql_install_db --user=mysql --datadir=/JY/data/
?
root@nginx1 /usr/local/mysql > cp support-files/my-large.cnf /etc/my.cnf?
root@nginx1 /usr/local/mysql > cp support-files/mysql.server /etc/init.d/mysqld
root@nginx1 /usr/local/mysql > chkconfig mysqld --add
root@nginx1 /usr/local/mysql > chkconfig mysqld on
?
root@nginx1 /usr/local/mysql > echo 'PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
root@nginx1 /usr/local/mysql > chmod +x /etc/profile.d/mysql.sh
root@nginx1 /usr/local/mysql > source /etc/profile.d/mysql.sh
?
root@nginx1 /usr/local/mysql > echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf
root@nginx1 /usr/local/mysql > ldconfig?
root@nginx1 /usr/local/mysql > ldconfig -v |grep mysql
/usr/local/mysql/lib:
libmysqlclient.so.18 -> libmysqlclient_r.so.18.0.0
/usr/lib64/mysql:
libmysqlclient_r.so.16 -> libmysqlclient_r.so.16.0.0
libmysqlclient.so.16 -> libmysqlclient.so.16.0.0
root@nginx1 /usr/local/mysql >?
?
root@nginx1 /usr/local/mysql > ln -s /usr/local/mysql/include /usr/include/mysql
?
root@nginx1 ~ > /etc/init.d/mysqld start
Starting MySQL.[ ?OK ?]
root@nginx1 ~ >?
?
5) 配置Mysql配置文件
root@nginx1 ~ > vi /etc/my.cnf?
root@nginx1 ~ > grep -v ^# /etc/my.cnf |grep -v ^$
[client]
port= 3306
socket ?= /tmp/mysql.sock
[mysqld]
port= 3306
socket ?= /tmp/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 4
datadir = /JY/data
innodb_file_per_table = 1
log_error = /JY/data/jy.err
general_log = ON ??
general_log_file = /JY/data/general.log
slow_query_log = ON?
slow_query_log_file = /JY/data/jy_slow.log?
innodb_buffer_pool_size = 1024M
innodb_log_file_size = 512M
innodb_buffer_pool_instances=4
innodb_read_io_threads = 8
innodb_write_io_threads = 8
max_allowed_packet = 128M
innodb_flush_method=O_DIRECT
max_connections = 1000
max_user_connections = 1000
skip_name_resolve = ON
transaction_isolation = READ-COMMITTED
log-bin=/JY/binlog/jy-bin
binlog_format=mixed
server-id ? = 1
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
?
6) 重启Mysql
root@nginx1 ~ > /etc/init.d/mysqld restart
Shutting down MySQL... [ ?OK ?]
Starting MySQL.............. ? [ ?OK ?]
root@nginx1 ~ >?
?
7) 设置Mysql密码
MariaDB [mysql]> drop user ''@'localhost';
Query OK, 0 rows affected (0.00 sec)
?
MariaDB [mysql]> drop user ''@'nginx1.tianxiang.com';
Query OK, 0 rows affected (0.00 sec)
?
MariaDB [mysql]> select user,password,host from user;
+------+----------+----------------------+
| user | password | host |
+------+----------+----------------------+
| root | ?| localhost|
| root | ?| nginx1.tianxiang.com |
| root | ?| 127.