Linux under Yum install MySQL and uninstall

1. Check if you have installed:

Yum List installed mysql*

Rpm-qa | grep mysql*

2. Check that there are no installation packages:

Yum List mysql*

3. Install the MySQL client:

Yum install MySQL

4. Install the MySQL server side:

Yum Install Mysql-server

Yum Install Mysql-devel

5. Start && Stop

Database Character Set settings

MySQL config file/etc/my.cnf add Default-character-set=utf8

To start the MySQL service:

Service mysqld start or/etc/init.d/mysqld start

Boot start:

Chkconfig-add mysqld, check if boot boot settings are successful chkconfig--list | grep mysql*

Mysqld 0: Off 1: Off 2: Enable 3: Enable 4: Enable 5: Enable 6: Off

Stop it:

Service Mysqld Stop
If it does not start, check if the MYSQLD service is already open in the service

6. Login

To create a root administrator:

Mysqladmin-u Root Password 123456

Www.2cto.com

Login:

Mysql-u Root-p Enter the password.

Forgot Password:

Service Mysqld Stop

Mysqld_safe--user=root--skip-grant-tables

Mysql-u Root

Use MySQL

Update user set Password=password ("New_pass") where user= "root";

Flush privileges;

7. Remote Access

1. Modify localhost
Change the "host" entry in the "User" table in the "MySQL" database, changing from "localhost" to "%"
Mysql>use MySQL;
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>select host, user from user;
Mysql>flush privileges;

2. Designated authorization
Connect to the MySQL server from any host using Myuser/mypassword:
GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;

Use Myuser/mypassword to connect to the MySQL server from a host with IP 192.168.225.166:
GRANT all privileges on * * to ' myuser ' @ ' 192.168.225.166 ' identified by ' MyPassword ' with GRANT OPTION;

3. Pan-Authorized
Mysql-h Localhost-u Root
Mysql>Grant all privileges on * * to ' root ' @ '% ' with GRANT OPTION; //give any host access to the data as root
Mysql>FLUSH privileges;

troubleshoot problems with MySQL not being able to connect remotely

1, MySQL port is correct
View port occupancy through NETSTAT-NTLP , typically 3306 for the lower end. The use of the tool to connect to MySQL is to use the port. For example, My admin\my Query browser\mysql front and so on.

2. Check whether the user rights are correct
The user table of the MySQL library has two records: host is localhost and% (for security,% can be replaced with IP you need to connect externally).

3. See if the skip-networking has been/etc/mysql/my.cnf
Need to be dropped
Error: Error 2003 (HY000): Can ' t connect to MySQL server on ' 192.168.51.112 ' (111)

sudo gedit/etc/mysql/my.cnf
#skip-external-locking

#bind-address = 127.0.0.1

Skip-name-resolve

4, check whether the iptables is stopped, does not close the case, can not connect
By: Service Iptables stop is temporarily closed.
Error: Error 2003 (HY000): Can ' t connect to MySQL server on ' 192.168.51.112 ' (113)

8. Linux several important directories for MySQL

Www.2cto.com

Database directory

/var/lib/mysql/

Configuration file

/usr/share/mysql (mysql.server command and configuration file)

Related commands

/usr/bin (Mysqladmin mysqldump and other commands)

Startup scripts

/etc/rc.d/init.d/(startup script file for MySQL directory)


Uninstall MySQL
1. Find out if MySQL was previously installed
Command: Rpm-qa|grep-i MySQL
You can see two of the MySQL packages:
mysql-*. *. rhel**
mysqlclient*. rhel**
2. Delete MySQL
Delete command: RPM-E--nodeps package Name
(Rpm-ev mysql-*. rhel*)
3, delete the old version of MySQL development header files and libraries
Command: Rm-fr/usr/lib/mysql
Rm-fr/usr/include/mysql
Note: The data and/etc/my.cnf in/var/lib/mysql after uninstallation are not deleted, if determined, then manually deleted
Rm-f/etc/my.cnf
Rm-fr/var/lib/mysql

There's another way.

Yum-style installation of MySQL

1. Yum remove MySQL mysql-server mysql-libs compat-mysql51

2, Rm-rf/var/lib/mysql

3, RM/ETC/MY.CNF

See if you have MySQL software:
Rpm-qa|grep MySQL

If it exists, continue with the deletion.

RPM-style installation of MySQL

A) Check to see if MySQL is installed in the RPM package on the system:

[Email protected] opt]# Rpm-qa | Grep-i MySQL
mysql-server-5.6.17-1.el6.i686
mysql-client-5.6.17-1.el6.i686

b) Uninstall MySQL

[Email protected] local]# rpm-e mysql-server-5.6.17-1.el6.i686
[Email protected] local]# rpm-e mysql-client-5.6.17-1.el6.i686

c) Delete MySQL service

[Email protected] local]# Chkconfig--list | Grep-i MySQL
[[email protected] local]# chkconfig--del MySQL

d) Delete the distributed MySQL folder

[[email protected] local]# Whereis MySQL or find/-name MySQL

MySQL:/usr/lib/mysql/usr/share/mysql

Empty all directories and files related to MySQL
Rm-rf/usr/lib/mysql
Rm-rf/usr/share/mysql

Rm-rf/usr/my.cnf

With these steps, MySQL should have been completely uninstalled.

The entire process of uninstalling and installing MySQL under Linux

Uninstall MySQL

1. Find out if MySQL was previously installed

Command: Rpm-qa|grep-i MySQL

You can see two of the MySQL packages:

mysql-4.1.12-3.rhel4.1

mysqlclient10-3.23.58-4.rhel4.1

2. Delete MySQL

Delete command: RPM-E--nodeps package Name

(Rpm-ev mysql-4.1.12-3.rhel4.1)

3, delete the old version of MySQL development header files and libraries

Command: Rm-fr/usr/lib/mysql

Rm-fr/usr/include/mysql

Note: The data and/etc/my.cnf in/var/lib/mysql after uninstallation are not deleted, if determined, then manually deleted

Rm-f/etc/my.cnf

Rm-fr/var/lib/mysql

Install MySQL

Pre-installation: two RPM packages

mysql-client-5.1.20-0.glibc23.i386.rpm

mysql-server-5.1.20-0.glibc23.i386.rpm

1, install the service side:

Command: RPM-IVH mysql-server-5.1.20-0.glibc23.i386.rpm

Installation success will appear ....

Warning:mysql-server-5.1.20-0.glibc23.i386.rpm:v3 DSA Signature:nokey, key ID 5072e1f5

Preparing ... ########################################### [100%]

1:mysql-server ########################################### [100%]

080220 13:58:27 [Note] Plugin ' InnoDB ' disabled by command line option

080220 13:58:28 [Note] Plugin ' InnoDB ' disabled by command line option

REMEMBER to SET A PASSWORD for the MySQL root USER!

To does so, start the server, then issue the following commands:

/usr/bin/mysqladmin-u root password ' new-password '

/usr/bin/mysqladmin-u root-h localhost.localdomain password ' new-password '

See the Manual for more instructions.

Problems with The/usr/bin/mysqlbug script!

The latest information about MySQL was available on the Web at

Http://www.mysql.com

Support for MySQL by buying support/licenses at http://shop.mysql.com

Starting MySQL. [OK]

2. Install the Client

Command: RPM-IVH mysql-client-5.1.20-0.glibc23.i386.rpm

Successful performance:

[Email protected] ~]# RPM-IVH mysql-client-5.1.20-0.glibc23.i386.rpm

Warning:mysql-client-5.1.20-0.glibc23.i386.rpm:v3 DSA Signature:nokey, key ID 5072e1f5

Preparing ... ########################################### [100%]

1:mysql-client ########################################### [100%]

3. Log in to MySQL

The command to log in to MySQL is mysql,mysql using the following syntax:

MySQL [-u username] [-h host] [-p[password]] [dbname]

Username and password are mysql user name and password, MySQL's initial management account is root, no password, note: This root user is not a Linux system user. MySQL Default user is root, because the initial no password, the first time to enter the only need to type MySQL

[[email protected] ~]# MySQL

Welcome to the MySQL Monitor. Commands End With; or \g.

Your MySQL Connection ID is 2

Server Version:5.1.20-beta MySQL Community Server (GPL)

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the buffer.

Mysql>

There is a "mysql>" prompt, congratulations, installation success!

The login format after adding the password is as follows:

Mysql-u root-p

Enter Password: (enter password)

Where-u followed by the user name,-p requires a password, enter the password at the input password.

Note: This MySQL file is in the/usr/bin directory, and the boot file/etc/init.d/mysql is not a file.

Tween

Detailed procedures for installing, configuring, and uninstalling MySQL via RPM packages.

Take mysql-server-4.0.14-0.i386.rpm as an example and put it in the/data directory

Cd/data

RPM-IVH mysql-server-4.0.14-0.i386.rpm

After the installation is complete, there will be a MySQL startup script in the/usr/share/mysql directory Mysql.server and sample configuration files (such as MY-HUGE.CNF, MY-LARGE.CNF, MY-MEDIUM.CNF)

Copy a sample configuration file as a configuration file for MySQL:

Cp/usr/share/mysql/my-medium.cnf/etc/my.cnf

When the RPM package is installed, MySQL is automatically installed as a system service, so you can start and stop MySQL using the following command

Start MySQL

/etc/init.d/mysql start or service MySQL start

Stop MySQL

/etc/init.d/mysql stop or service MySQL stop

To this, the MySQL service is complete on the installation configuration.

Installing the MySQL Client

RPM-IVH mysql-client-4.0.14-0.i386.rpm

MySQL is installed after the directory structure is as follows:

The utility program is---ls/usr/bin/mysql* in the/usr/bin directory

Server program/usr/sbin/mysqld

Data Catalog/var/lib/mysql

By default, MySQL writes error log files, binary log files, and process files in the/var/lib/mysql directory, such as Localhost.err, Localhost.pid, localhost-bin.001, and so on.

To change these conditions, you can modify the/etc/my.cnf file

If you write the log file in the/var/log directory, you can add the following two lines to the my.cnf file:

[Mysqld_safe]

Err-log =/var/log/mysqld.log

There is a utility/usr/bin/mysql_install_db, which can be used to initialize the MySQL database, that is to create the/var/log/mysql directory, and to create a MySQL database (MySQL authorization table and other information) and test database (empty library), If you accidentally delete the/var/log/mysql directory, you can initialize it by using the program.

Uninstall MySQL

Rpm-qa|grep-i MySQL

Rpm-ev mysql-server-4.0.14-0 mysql-client-4.0.14-0

Data and/ETC/MY.CNF in/var/lib/mysql will not be removed after uninstallation, and will be removed manually if determined to be useless.

Rm-f/etc/my.cnf

Rm-rf/var/lib/mysql

MySQL 1130 Error resolution method:

This error occurs when you connect to MySQL via Mysql-front or MySQL administrator

ERROR 1130:host ***.***.***.*** isn't allowed to connect to this MySQL server

Indicates that the connected user account does not have remote connection permissions and can only log on natively (localhost).

You need to change the host entry in the user table in the MySQL database

Rename localhost to%

Specific steps: Login to MySQL

First use MySQL;

There was an error when the update was provided in the other way.

mysql> Update user set host= '% ' where user = ' root ';

ERROR 1062 (23000): Duplicate entry '%-root ' for key ' PRIMARY '

The host information for the following database is then viewed as follows:

Mysql> Select host from user where user = ' root ';

+-----------------------+

| Host |

+-----------------------+

| % |

| 127.0.0.1 |

| Localhost.localdomain |

+-----------------------+

3 Rows in Set (0.00 sec)

The host already has the% value, so run the command directly:

Mysql>flush privileges;

Then connect with MySQL administrator ... Success!!!

tar.gz Version Installation:

Version 1:

1. Place and unzip the MySQL installation package into the/usr/local

Tar zxvf mysql-standard-5.0.27-linux-i686-glibc23.tar.gz

2. Create a symbolic link for a table of contents

Ln-s mysql-standard-4.0.24-pc-linux-gnu-i686 MySQL

3. Build MySQL groups and users

Groupadd MySQL

useradd-g MySQL MySQL

4. Change the user and group of the MySQL directory

Chown-r MySQL. #注意保证此时的当前目录是/usr/lcoal/mysql

Chgrp-r MySQL.

5. Execute configuration script with MySQL user

Su MySQL #切换到mysql用户

Cd/usr/local/mysql #注意切换用户以后, the working directory is not/usr/local/mysql. So we have to go back in.

./configure #执行配置脚本

6. Enter the database to check if the installation was successful

/usr/local/mysql/bin/mysql

If a MySQL prompt appears and enters, the installation is successful!

7. Automatically turn on the MySQL service when the system starts

su-#切换回root用户

Cd/usr/local/mysql

CP Support-files/mysql.server/etc/rc.d/init.d/mysql #把mysql的脚本文件拷到系统的启动目录下

cd/etc/rc.d/init.d/

chmod +x MySQL #改为可执行文件属性

Chkconfig--add MySQL #将mysql加到启动服务列表里

Chkconfig MySQL on #让系统启动时自动打开mysql服务

After restarting the system, execute/usr/local/mysql/bin/mysql, if a MySQL prompt appears indicating that the entire installation was successful

Version 2:

Mysql-standard-4.0.24-pc-linux-gnu-i686.tar.gz is a mysql4.0.24 version of the installation file, is a binary compression package, so our installation method for the binary distribution installation.

Installation steps:

1. Copy the mysql-standard-4.0.24-pc-linux-gnu-i686.tar.gz to a directory

2. Shell> Tar zvxf mysql-standard-4.0.24-pc-linux-gnu-i686.tar.gz

3. The above command will generate a mysql-standard-4.0.24-pc-linux-gnu-i686 folder in the current directory

4. SHELL>MV Mysql-standard-4.0.24-pc-linux-gnu-i686/usr/local/mysql

5. The above command is to mysql-standard-4.0.24-pc-linux-gnu-i686 all the east, cut to/usr/local/mysql under, this step is for the convenience of the future.

6. shell> groupadd MySQL Add a user group named MySQL

7. shell> useradd-g mysql mysql add a user named MySQL to the MySQL user group

If the above two commands cannot be executed, then switch to the root user to execute the

SHELL>SU Root-

8. Shell> Cd/usr/local/mysql

9. shell> CP support-files/my-medium.cnf/etc/my.cnf

This will ask whether to overwrite the duplicate file, answer Y

10.shell> scripts/mysql_install_db--user=mysql

To initialize the database with a MySQL user, the MySQL user must

11.shell> Chown-r Root

Note that the following is a bit, which means that all files in the current directory are set with the owner of the subdirectory

Set as root user

12.shell> chown-r MySQL Data

Indicates that the owner of the data directory under the current directory is set as a MySQL user

13.shell> chgrp-r MySQL.

Note that the following is a bit, which indicates that the file group for the file under the current directory is set to the MySQL group

14.shell> Bin/mysqld_safe--user=root &

If the word "... ended" does not appear, you are done!

15. Enter Display shell>

At this point you can

See if Port 3306 is enabled with the SHELL>NETSTAT–ATLN command

You can also Shell>ps-ef | grep mysqld View the process of mysqld in the current system

or directly shell>bin/mysql–u root into the MySQL client for MySQL operation

Or shell>bin/mysqladmin shutdown stop MySQL service

Remember: At this point your root user does not have a password, any identity can be entered with root, you can

by shell> bin/mysqladmin-u root password ' new password ' to set the root user's password, this password will need to enter the MySQL client and stop the MySQL service

Tip: When starting a single service, you can configure it by modifying the/etc/my.cnf file

You can use the VI editor to open MY.CNF, how to open it, see below

Shell>vi MY.CNF Open MY.CNF

Find the following paragraph

[Mysqld]

Port = 8888

Socket =/tmp/mysql.sock

You can add the appropriate configuration to the following

Log =/var/log/mysql.log

DataDir =/free/mysqldbf

If log =/* Change the location of log save

DataDir =/free/mysqldbf Change the save location of data

I hope I have a little bit of help with friends who meet the same problem

Common commands:

Start MySQL:

Service MySQL Start

/etc/init.d/mysql start

/usr/share/mysql/mysql.server start

[Mysql.server]

# comment out Basedir line, otherwise MySql may not start

# is said to be a MYSQL bug

# Basedir=/var/lib

When root logs on, automatically starts MySQL:

Add 1 lines to the/root/.bash_profile file:

/usr/share/mysql/mysql.server start

To view the boot log:

/var/log/messages

Show MySQL All users:

Use MySQL;

Select Host,user,password from user;

To add a MySQL user (Name:user1,password:sql):

Grant all on * * to [e-mail protected] '% ' identified by ' SQL ' with GRANT option;

To delete a MySQL User:

Delete from user where user= ' user1 ';

To configure environment variables:

Path= $JAVA _home/bin: $CATALINA _home/bin:/usr/local/mysql/bin: $PATH

Linux yum install MySQL and uninstall