?????????????
????Step1: ????????????mysql???????centos???mysql5.1??У???????????????????????????????mysql
????yum list installed | grep mysql
????Step2: ??????????mysql????????????
????yum -y remove mysql-libs.x86_64
????Step3: ??CentOS???rpm????????????μ??????
????wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
????yum localinstall mysql-community-release-el6-5.noarch.rpm
????yum repolist all | grep mysql
????yum-config-manager --disable mysql55-community
????yum-config-manager --disable mysql56-community
????yum-config-manager --enable mysql57-community-dmr
????yum repolist enabled | grep mysql
??????????Step4?????mysql ??????????
????yum install mysql-community-server
????Step5: ???mysql????
????service mysqld start
????Step6: ??mysql??????????????????????????????
????chkconfig --list | grep mysqld
????chkconfig mysqld on
????mysql5.7????????ο??????root?????????????
????mysql5.7?????????????????????????????????????????????mysql???????mysql -u root??????????????е?sql????????????????????mysql5.7?????в?????????????????????????????mysql5.7?????????????????“access denied for user root@localhost” ?????????????????????????
????Step1: ??mysqld???????mysqld safe???
????service mysqld stop
????mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
????RHEL7.0??е???а棨????CentOs 7???????????????systemd????????е?init?????????????????????????????????mysqld_secure?????????á????????????????????????????mysqld??????????mysqld_safe??????????????￡?
????mysqld   --user=mysql --skip-grant-tables --skip-networking &
????Step2?????mysql
?????????????mysql???????????
????mysql -uroot -p
??????????mysql??
????Step3: ????mysql???????
?????????????mysql5.7???????????????????MYSQL5.6????????????????????root???????mysql?????????Σ??????????????????root??????mysql???????????????????????Mysql??user???????????????
?????????????????????????/var/log/mysql.log??????????а????Mysql????????????????????????????????????????????????????????￡?????????????????裩
????mysql> SET PASSWORD = PASSWORD('ur password here');
????????????????????
????ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
????????????
????update mysql.user set authentication_string=password('newpassword') where user='root'
????Step4??????mysql root????????Step3?б?????￡?
????update mysql.user set authentication_string=password('newpassword') where user='root'
????????mysql?汾???
????UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
????flush privileges;
??????mysql5.7?????PASSWORD??θ???????"authentication_string"??????????????????????
????Step5?????????????????root???
????GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'ur password here' WITH GRANT OPTION;
????Step6??????????mysql workbench????????root???????????????
????MYSQL??????????????
????????CPU 6C
??????棺6GB
??????????????????￡?
????# For advice on how to change settings please see
????# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
????[mysqld]
????#
????# Remove leading # and set to the amount of RAM for the most important data
????# cache in MySQL. Start at 70% of total RAM for dedicated server?? else 10%.
????# innodb_buffer_pool_size = 128M
????#
????# Remove leading # to turn on a very important data integrity option: logging
????# changes to the binary log between backups.
????# log_bin
????#
????# Remove leading # to set options mainly useful for reporting servers.
????# The server defaults are faster for transactions and fast SELECTs.
????# Adjust sizes as needed?? experiment to find the optimal values.
????join_buffer_size = 128M
????sort_buffer_size = 6M
????read_rnd_buffer_size = 4M
????#deprecate this option after mysql5.5 default-character-set = utf8
????character-set-server=utf8
????open_files_limit    = 10240
????back_log = 384
????max_connections = 500
????#deprecate this option after mysql5.5 table_cache = 512K
????max_allowed_packet =16M
????query_cache_size = 384M
????table_open_cache = 512
????key_buffer_size = 384M
????datadir=/var/lib/mysql
????socket=/var/lib/mysql/mysql.sock
????# Disabling symbolic-links is recommended to prevent assorted security risks
????symbolic-links=0
????log-error=/var/log/mysqld.log
????pid-file=/var/run/mysqld/mysqld.pid
????slow_query_log_file = /var/log/mysqld-slow-query.log 
????log-short-format
????long-query-time = 3 
????#log-long-format 
????#log-slow-admin-statements 
????log-queries-not-using-indexes