Mysql server advanced 5.6 installation, mysql5.6
There are two types of mysql installation: rpm installation and source code package installation. Both packages can be downloaded from www.mysql.com. I will test the rpm installation method this time.
1. installation environment and mysql version:1.1 vcenter 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. Install mysql.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 package mysql-libs-5.1.73-3.el6_5.x86_64 as above, some errors may occur. Check the cause. The package in the operating system conflicts with the mysql package to be installed. We only need to configure yum and package and remove these packages. Yum groupremove mysqlyum remove mysql-libs-5.1.73-3.el6_5.x86_64 and install rpm-ivh MySQL-server-advanced-5.6.21-1.el6.x86_64.rpm2.2 again. Next we install client connection. MySQL-client-advanced-5.6.21-1.el6.x86_64.rpm
3. log on to the mysql server.3.1 check the mysql status. Service mysql status can be started if it is not started: service mysql start3.2 try to connect to the database server mysql-u root-pERROR 1045 (28000 ): access denied for user 'root' @ 'localhost' (using password: NO) 3.3 the first time a mysql root Account had a default password, prompting a random password, in the current root user's home /. mysql_secret. 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, the root account of the operating system 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 & -- start mysql in safe mode # mysql-u root --- directly log on to mysql> update user set password = password ('newpassword ') where user = 'root'; mysql> flush privileges; -- the modification takes effect immediately and does not take effect. In any case, restart mysql> quit; #/etc/init. d/mysql restart # mysql-u root-p enter new password: mysql> --- login successful ----------------------------
4. Client connection. (I checked some information, SQLyog and navicat are good, and navicat lite is a good developer. You can connect to oracle, mssqlsever, mysql, and PostgreSql.4.1 disable the Firewall service iptables stopchkconfig iptables off4.2 modify the remote connection configuration of the connected user to open the specified user, such as the root remote login permission, open Port 3306 mysql> grant all PRIVILEGES on * in iptables *. * to root @ 'localhost' identified by 'newpwd'; the latter modifies the host field in the user table to %. If it is a root user, note that host is the primary key. Mysql> update user set host = '%' where host = 'localhost'; we recommend that you use the first method. When testing other new users, the second method has a problem. Mysql> flush privileges; ------------- 4.3 remote telnet xxx. xxx 3306 Success ~ You can use a client to connect.
