2019獨角獸企業重金招聘Python工程師標準>>>

安裝mysql
yum install -y mysql-server?? ?

service mysqld start??? 啟動服務
service mysqld stop??? 關閉服務

修改/ect/my.cnf，如果文件不存在，直接創建，修改內容如下：
[mysqld]
transaction-isolation=READ-COMMITTED
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

key_buffer????????????? = 16M
key_buffer_size???????? = 32M
max_allowed_packet????? = 32M
thread_stack??????????? = 256K
thread_cache_size?????? = 64
query_cache_limit?????? = 8M
query_cache_size??????? = 64M
query_cache_type??????? = 1

max_connections???????? = 550

# log_bin should be on a disk with enough free space
# NOTE: replace '/x/home/mysql/logs/binary' below with
#?????? an appropriate path for your system.
log_bin=/usr/local/mysql/mysql/logs/binary/mysql_binary_log

# For MySQL version 5.1.8 or later. Comment out binlog_format for older versions.
binlog_format?????????? = mixed

read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

創建目錄：
mkdir -p /usr/local/mysql/mysql/logs/binary/
chown mysql /usr/local/mysql/mysql/logs/binary/
sudo -u mysql touch /usr/local/mysql/mysql/logs/binary/mysql_binary_log.index


配置：/usr/bin/mysql_secure_installation
配置過程中，除了Disallow root login remotely？設置為n，其余全部設置為y。

啟動服務，登錄：mysql -uroot -p123456
創建數據庫：
create database amon DEFAULT CHARACTER SET utf8;
create database rman DEFAULT CHARACTER SET utf8;
create database metastore DEFAULT CHARACTER SET utf8;
create database sentry DEFAULT CHARACTER SET utf8;
create database nav DEFAULT CHARACTER SET utf8;
create database navms DEFAULT CHARACTER SET utf8;
create database scm DEFAULT CHARACTER SET utf8;

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;

show engines，如果發現沒有InnoDB引擎，卸載mysql數據庫，從新安裝，沒有InnoDB引擎有可能是在my.cnf中配置了InnoDB相關參數，
去掉在my.cnf中所有有關InnoDB的參數配置，卸載步驟如下：

yum remove -y mysql-server?? ?
rm -rf /var/lib/mysql/ /usr/local/mysql/ /var/log/mysqld.log /var/run/mysqld.pid /etc/my.cnf

重新安裝，執行以上步驟；

設置mysql開機啟動：
sudo /sbin/chkconfig mysqld on;
sudo /sbin/chkconfig --list mysqld;

轉載于:https://my.oschina.net/sniperLi/blog/664571

總結

以上是生活随笔為你收集整理的centos在线安装mysql的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。