MySQL installation has two, RPM installation and source package installation, both packages can be downloaded from the Www.mysql.com official website, this time I test the RPM installation method.
1. Installation environment and MySQL version:1.1vcenter Virtual Machine Environment 1.2 operating system Oracle Linux 6.61.3MYSQL Server version: Mysql-server-advanced-5.6.21-1.el6.x86_64.rpm1.4mysql Client version: mysql-client-advanced-5.6.21-1.el6.x86_64.rpm
2.mysql installation. 2.1 Rpm-ivh MYSQL-SERVER-ADVANCED-5.6.21-1.EL6.X86_64.RPMRPM-IVH mysql-server-advanced-5.6.21-1.el6.x86_64.rpm
Preparing ... ########################################### [100%]
File/usr/share/mysql/czech/errmsg.sys from install of mysql-server-advanced-5.6.21-1.el6.x86_64 conflicts with file From Package mysql-libs-5.1.73-3.el6_5.x86_64
File/usr/share/mysql/danish/errmsg.sys from install of mysql-server-advanced-5.6.21-1.el6.x86_64 conflicts with file From Package mysql-libs-5.1.73-3.el6_5.x86_64
File/usr/share/mysql/dutch/errmsg.sys from install of mysql-server-advanced-5.6.21-1.el6.x86_64 conflicts with file From the package mysql-libs-5.1.73-3.el6_5.x86_64, you will encounter some errors. To see why, the package that comes with the operating system and the MySQL-related package to be installed conflicts. We just need to configure Yum to pack the packages and remove them. Yum groupremove Mysqlyum Remove mysql-libs-5.1.73-3.el6_5.x86_64 and then install again RPM-IVH mysql-server-advanced-5.6.21-1.el6.x86_64.rpm2.2 Next we install the client connection. mysql-client-advanced-5.6.21-1.el6.x86_64.rpm
3. server MySQL login connection. 3.1 Check the MySQL status. Service MySQL status can start if not started: service MySQL start3.2 attempt to connect to database server Mysql-u root-perror 1045 (28000): Access denied for User ' root ' @ ' localhost ' (using Password:no) 3.3 The first time the MySQL root account has a default password, the hint is a random password, in the Home/.mysql_secret of the current root user . After logging in, we can change the root password. set PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' newpwd '); ---------------------------------------------- -------------of course, if our MySQL root account is lost, as long as there is an operating system root account can be bypassed, the method is as follows: #/etc/init.d/mysql stop ---stop MySQL service # Mysqld_safe--user=mysql--skip-grant-tables--skip-networking & --Safe mode start mysql#mysql -u root --- Direct login mysql>update User set Password=password (' NewPassword ') where user= ' root '; mysql>flush privileges; --modification takes effect immediately, can not be executed, anyway a restart service mysql>quit;#/etc/init.d/mysql restart # mysql-u root-p Enter new password:mysql> ---login successful----------------------------
4. Client connection. (I looked up some information, sqlyog and Navicat good, Navicat Lite personal version Development with good, can connect Oracle,mssqlsever,mysql,postgresql4.1 Turn off Firewall service iptables stopchkconfig iptables off4.2 Modify connection user remote connection configuration open specified user, such as root Telnet permission, need to open 3306 port in iptables MySQL >grant all privileges on * * to [e-mail protected] ' localhost ' identified by ' newpwd '; The latter modifies the host field in the user table to%, and if it is root, note that host is the primary key. Mysql>update user set host= '% ' where host= ' localhost '; it is recommended that in the first way, when I test other new users, the second way is problematic. Mysql>flush privileges;-------------4.3 remote telnet xxx.xxx.xxx.xxx 3306 Successful ~ can be connected with a client.
MySQL Server Advanced 5.6 Installation
