Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the download, installation and activation of mysql under Linux". In the daily operation, I believe many people have doubts about the download, installation and activation of mysql under Linux. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "download, installation and activation of mysql under Linux". Next, please follow the editor to study!

Under Linux

Download the mysql installation package:

1.1 installation package name

MySQL-client-5.6.12-2.linux_glibc2.5.x86_64.rpm

MySQL-server-5.6.12-2.linux_glibc2.5.x86_64.rpm

MySQL-devel-5.6.12-2.linux_glibc2.5.x86_64.rpm

1.2 download address:

Http://dev.mysql.com/downloads/mysql-4.0.html#downloads

Select "Linux-Generic" on the page

Second, install mysql:

Rpm-ivh MySQL-client-5.6.12-2.linux_glibc2.5.x86_64.rpm

Rpm-ivh MySQL-server-5.6.12-2.linux_glibc2.5.x86_64.rpm

Rpm-ivh MySQL-devel-5.6.12-2.linux_glibc2.5.x86_64.rpm

3. Start mysql service

3.1View mysql startup status:

/ etc/rc.d/init.d/mysql status

3.2 launch mysql:

Service mysql start

4. Execute commonly used commands:

4.1 Log in to mysql

Mysql-u root-p

4.2 execute the mysql command

> show databases

> use mysql

> show tables

5. Uninstall mysql

5.1 check to see if mysql has been previously installed:

Rpm-qa | grep-I mysql

The installed package name is displayed:

MySQL-server-5.6.12-2.el6.x86_64

Perl-DBD-MySQL-4.013-3.el6.x86_64

Mysql-connector-odbc-5.1.5r1144-7.el6.x86_64

MySQL-client-5.6.12-2.el6.x86_64

MySQL-python-1.2.3-0.3.c1.1.el6.x86_64

5.2 Uninstall:

Rpm-e-- nodeps MySQL-server-5.6.12-2.el6.x86_64

5.3 delete the development header files and libraries of the old version of mysql:

Rm-rf / usr/lib/mysql

Rm-rf / usr/include/mysql

Rm-rf / varr/lib/mysql

5.4 references:

Http://blog.sina.com.cn/s/blog_48d5933f0100ts7t.html

5.5 another way to delete:

Yum remove mysql

VI. Common mistakes

6.1 MYSQL login error: mysqladmin: connect to server at 'localhost' failed

Service mysql stop

Mysqld_safe-- skip-grant-tables &

Enter mysql-u root-p to enter

> use mysql

> update user set password=PASSWORD ("love") where user= "root"; change password

Update permissions for flush privileges;

> quit exit

6.2 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

Set password=password ("love")

Under windows

Download the mysql installation package:

1.1 installation package name

Mysql-installer-community-5.6.12.2.msi

1.2 download address:

Http://dev.mysql.com/downloads/mysql-4.0.html#downloads

Select "Microsoft Windows" on the page

Http://dev.mysql.com/downloads/installer/5.6.html

Second, install mysql:

Double-click mysql-installer-community-5.6.12.2.msi to follow the prompts to install.

3. Start mysql service

3.1 graphical startup

Control Panel-> Systems and Security-> Administrative tools-> Services

Locate MySQL56 and execute start / stop.

3.2 Command Line start

Start cmd as an administrator and execute:

Net start MySQL56

Net stop MySQL56

4. Several common commands:

4.1 Log in to mysql

Start-> all programs-> MySQL-> MySQL Server 5.6-> MySQL 5.6Command Line Client.

4.2 execute the mysql command

> show databases

> use mysql

> show tables

5. Uninstall mysql

VI. Common mistakes

Execute net start MySQL56 under cmd, prompting "system error 5. Access denied."

Start cmd as an administrator.

At this point, the study on the "download, installation and enabling methods of mysql under Linux" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.