redhat6.4 installation mysql-server-5.5.28-1.linux2.6.x86_64.rpm

Source: Internet
Author: User
Tags local time

Download the following three files first:

mysql-server-5.5.28-1.linux2.6.x86_64.rpm

mysql-client-5.5.28-1.linux2.6.x86_64.rpm

mysql-devel-5.5.28-1.linux2.6.x86_64.rpm

Then log in using the root account to install:

1. Install server, devel, client:1. Install server, devel, client:

RPM-IVH--replacefiles mysql-s*.rpm

RPM-IVH--replacefiles mysql-d*.rpm

RPM-IVH--replacefiles mysql-c*.rpm

[Email protected] ~]# RPM-IVH--replacefiles mysql-server-5.5.28-1.linux2.6.x86_64.rpm

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

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

[Email protected] ~]# RPM-IVH--replacefiles mysql-client-5.5.28-1.linux2.6.x86_64.rpm

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

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

[Email protected] ~]# RPM-IVH--replacefiles mysql-devel-5.5.28-1.linux2.6.x86_64.rpm

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

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

To remove the installation can use Rpm-e Mysql-server, rpm-e mysql-devel, mysql-client can be;

2. Initialize the database:

/usr/bin/mysql_install_db

3. Start the MySQL service:

Service MySQL Start

Using Command Ps-ef | grep MySQL to view the MySQL process:

[[email protected] ~]# ps-ef|grep mysql root 3708 3057 0 18:39 pts/1 00:00:00 grep mysql

4. First login to set the root password:

First look at Cat/root/.mysql_secret//Sometimes you can't find it, don't look down.

[Email protected] ~]# Cat/root/.mysql_secret

# The random password set for the root user at Fri 15:57:18 (local time): fmycarvb This online says I didn't do it anyway.

Then the command line: Mysql-u root-p, then enter the above password:

[Email protected] ~]# mysql-uroot-p Enter password:welcome to the MySQL monitor. Commands End With; or \g. Your MySQL connection ID is 1 server version:5.5.28 mysql Community server (GPL)

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

Oracle is a registered trademark of the Oracle Corporation and/or its affiliates. Other names trademarks of their respective owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

To set the root password:

mysql> use MySQL

Database changed

mysql> Update user Set Password=password (' root ') where user= ' root ';

Query OK, 0 rows affected (0.15 sec)

Rows Matched:5 changed:0 warnings:0

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

Exit, re-login can use the new password login;

5. Set up remote login:

After logging in to MySQL with Root

Switch to MySQL database

mysql> show databases; +--------------------+ | Database | +--------------------+ | Information_schema | | MySQL | | Performance_schema | | Test | +--------------------+ 4 rows in Set (0.00 sec)

Mysql> Update user set host= '% ' where user= ' root '; ERROR 1046 (3d000): No database selected mysql> use MySQL Reading table information for completion of table and column Names can turn off this feature to get a quicker startup with-a

Database changed mysql> update user set host= '% ' where user= ' root '; ERROR 1062 (23000): Duplicate entry '%-root ' for key ' PRIMARY ' mysql> select Host,user from user; +-----------------------+------+ | host                  | user | +-----------------------+------+ | %                      | Root | | 127.0.0.1             | Root | | ::1                    | Root | | localhost             |       | | Localhost.localdomain |      | | Localhost.localdomain | Root | +-----------------------+------+ 6 rows in Set (0.00 sec)

And then:

Mysql> Grant all privileges on * * to ' root ' @ ' @ ' with GRANT option; ERROR 1105 (HY000): malformed hostname (illegal symbol: ' @ ') Mysql> grant all privileges on * * to ' root ' @ '% ' with gran T option; Query OK, 0 rows Affected (0.00 sec)

Mysql> exit

Bye

[[Email protected] ~]# service MySQL restart

Shutting down MySQL. success!

Starting MySQL. success!

You can log in remotely by restarting MySQL.

redhat6.4 installation mysql-server-5.5.28-1.linux2.6.x86_64.rpm

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.