Reference documents ：http://blog.csdn.net/superchanon/article/details/8546254

 RPM Installation steps

a.       Check that... Is installed ,grep Of -i Option means ignore case when matching

[[email protected] JavaEE]#rpm -qa|grep -i mysql

mysql-libs-5.1.61-4.el6.x86_64

It can be seen that the library file has been installed , You should uninstall , Otherwise, an overwrite error will occur . Note that... Is used during uninstallation --nodeps Options , Ignoring dependencies ：

[[email protected] JavaEE]#rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps

2.     install MySQL Server side software for , Notice the switch to root user ：

[[email protected] JavaEE]#rpm -ivh MySQL-server-5.5.29-2.el6.x86_64.rpm

After installation , The installation process will Linux Add a mysql Group , And belong to mysql Group users mysql. It can be done by id Command view ：

[[email protected] JavaEE]#id mysql

uid=496(mysql)gid=493(mysql) groups=493(mysql)

MySQL After the server is installed, although the relevant files are configured , But it didn't start automatically mysqld service , It needs to start by itself ：

[[email protected] JavaEE]#service mysql start

Starting MySQL.. SUCCESS!

You can check whether the port is open MySQL Whether it starts normally ：

[[email protected] JavaEE]#netstat -anp|grep 3306

tcp        0     0 0.0.0.0:3306               0.0.0.0:*                   LISTEN      34693/mysqld

c.  install MySQL Client software ：

[[email protected] JavaEE]#rpm -ivh MySQL-client-5.5.29-2.el6.x86_64.rpm

If the installation is successful, you should be able to run mysql command , Note that it must be mysqld Service and opening ：

[[email protected] JavaEE]#mysql

Welcome to the MySQLmonitor.  Commands end with ; or \g.

Your MySQL connection idis 1

Server version: 5.5.29MySQL Community Server (GPL)

Copyright (c) 2000, 2012,Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademarkof Oracle Corporation and/or its affiliates. Other names may be trademarks oftheir respective owners.

Type 'help;' or '\h' forhelp. Type '\c' to clear the current input statement.

mysql>

d.  RPM Installation mode file distribution

mysql> select user,host from mysql.user;
+---------+-----------+
| user | host |
+---------+-----------+
| M1234 | % |
....
| root | localhost |
+---------+-----------+
4 rows in set (0.00 sec)

mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;  
mysql> FLUSH PRIVILEGES;  
mysql> quit  

c:> mysql -uroot -p  
Enter password: < Enter the new password newpassword> 

Reference documents ：http://blog.csdn.net/feng4656/article/details/9879591

Navicat windowns Lower remote connection linux Terminal mysql

We need to build up to Linux On MySQL Links to servers , Create a link , Name the link name , Fill in the server IP, Login user and password , And then link ~ It is possible that there will be an error when linking , Said there was no authorization , Be similar to Host '192.168.1.3' is not allowed to connect to this MySQL server Error of ~

The reason for this error is that there is no open remote link function , Can be in mysql The user is authorized in the client of the named row , For example, use command GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY ’password’ WITH GRANT OPTION; Yes root The user authorizes , Then you can link successfully ~

linux mysql Change user permissions

Reference documents http://www.jb51.net/LINUXjishu/10981.html

ERROR 1045 : Access denied for user [email protected] (using password: YES)