{"id":6869,"date":"2017-07-21T15:41:54","date_gmt":"2017-07-21T07:41:54","guid":{"rendered":"http:\/\/rmohan.com\/?p=6869"},"modified":"2017-07-21T15:41:54","modified_gmt":"2017-07-21T07:41:54","slug":"centos-7-rpm-installed-under-the-mysql-5-6-36","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=6869","title":{"rendered":"CentOS 7 rpm installed under the MySQL 5.6.36"},"content":{"rendered":"

CentOS<\/a>\u00a07 under the local installation of MySQL 5.7, but the springboot integration jpa will appear hibernateException, do not know why, for a MySQL5.6 version of MySQL, source installation, cmake has been through, and later into rpm installation.<\/p>\n

Local installation of mysql5.7, but the integration of springboot jpa will appear hibernateException, do not know why, for a mysql5.6 version of the mysql, source installation, cmake has been through, and later changed to rpm installation<\/p>\n

1, get mysql5.6<\/p>\n

\n
Ftp:\/\/ftp.mirrorservice.org\/sites\/ftp.mysql.com\/Downloads\/MySQL-5.6\/<\/pre>\n
download:\u00a0\"\"<\/p>\n
Where el6 identifies centos 6, el7 identifies centos 7<\/p>\n
2, installation<\/p>\n
\n
Rpm -ivh MySQL- *<\/pre>\n<\/div>\n
3, start<\/p>\n
\n
Systemctl start mysql<\/pre>\n<\/div>\n
4, view the initial password<\/p>\n
\n
Cat \/root\/.mysql_secret<\/pre>\n<\/div>\n
5, change the password<\/p>\n
\n
Mysql -uroot -pKAKt5JmEjm6B8omV\r\nSET PASSWORD = PASSWORD(<\/code>'root'<\/code>);<\/code><\/pre>\n<\/div>\n
6, remote login settings<\/p>\n
\n
Mysql> user mysql;\r\nMysql > select host, user, password from user;\r\nMysql > update user set password = password ( ' root ' ) where user = ' root ' ;\r\nMySQL > Update the User the SET Host = ' % '  the WHERE the User = ' root ' and Host = ' localhost ' ; \r\n\r\nauthorized \r\nGRANT\u00a0 ALL\u00a0 PRIVILEGES\u00a0 . ON * *\u00a0 the TO\u00a0 'root' @ '%' IDENTIFIED\u00a0 BY\u00a0 'Here is your password'\u00a0 the WITH\u00a0 GRANT<\/span><\/span><\/span><\/pre>\n<\/div>\n
7, set the boot start<\/p>\n
\n
[Root @ localhost ~ ] # chkconfig mysql on\r\n[Root @ localhost ~] # chkconfig --list | grep mysql<\/pre>\n<\/div>\n
8, MySQL default installation location<\/p>\n
\n
\/ Var \/ lib \/ mysql \/                # database directory\r\n \/ usr \/ share \/ mysql # configuration file directory\r\n \/ usr \/ bin # related command directory\r\n \/etc\/init.d\/mysql # start script<\/pre>\n<\/div>\n
9, modify the default character set and so on<\/p>\n
Vim \/etc\/my.cnf<\/p>\n
\n
\n
\n
[client]\u00a0<\/code><\/div>\n
password\u00a0 \u00a0 \u00a0 \u00a0 = root<\/code><\/div>\n
port\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 = 3306\u00a0<\/code><\/div>\n
default<\/code>-character-<\/code>set<\/code>=utf8\u00a0<\/code><\/div>\n
[mysqld]\u00a0<\/code><\/div>\n
port\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 = 3306\u00a0<\/code><\/div>\n
character_set_server=utf8\u00a0<\/code><\/div>\n
character_set_client=utf8\u00a0<\/code><\/div>\n
collation-server=utf8_general_ci\u00a0<\/code><\/div>\n
<\/div>\n
lower_case_table_names=1\u00a0<\/code><\/div>\n
<\/div>\n
max_connections=1000\u00a0<\/code><\/div>\n
[mysql]\u00a0<\/code><\/div>\n
default<\/code>-character-<\/code>set<\/code>\u00a0= utf8\u00a0<\/code><\/div>\n<\/div>\n<\/div>\n<\/div>\n
10, view the character set<\/p>\n
\n
Show variables like ' % collation% ' ;  \r\nShow variables like ' % char% ' ;<\/pre>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
CentOS 7 under the local installation of MySQL 5.7, but the springboot integration jpa will appear hibernateException, do not know why, for a MySQL5.6 version of MySQL, source installation, cmake has been through, and later into rpm installation.<\/p>\n
Local installation of mysql5.7, but the integration of springboot jpa will appear hibernateException, do not know why, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6869"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6869"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6869\/revisions"}],"predecessor-version":[{"id":6870,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/6869\/revisions\/6870"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}