Home > Database > Mysql Tutorial > How to install mysql on centos6.5

How to install mysql on centos6.5

PHPz
Release: 2023-04-21 14:10:06
Original
764 people have browsed it

CentOS 6.5 is a very popular Linux operating system version. Many people choose to use CentOS 6.5 as their server operating system, so installing MySQL on this system is an essential task. This article will provide detailed steps to help you install MySQL on CentOS 6.5.

  1. Installing MySQL

The easiest way to install MySQL on CentOS 6.5 is through the yum package manager. First, we need to open a Linux terminal and enter the following command to install MySQL:

sudo yum install mysql-server
Copy after login

This command will start the MySQL installation program and download and automatically install MySQL. We need to wait for a while, during which you will be prompted for the root user password and the MySQL administrator password.

  1. Start the MySQL service

After the installation process is completed, we need to start the MySQL service. Start MySQL through the following command:

sudo service mysqld start
Copy after login

If the installation is successful, you will see the following information:

Starting mysqld:  [ OK ]
Copy after login
  1. Configure MySQL

Default , the MySQL server will not allow access from the public network. Therefore, we need to configure the following to make MySQL accessible from other computers.

Open the MySQL configuration file and execute the following command:

sudo nano /etc/mysql/my.cnf
Copy after login

Find the following line in this file:

bind-address           = 127.0.0.1
Copy after login

Change it to:

# bind-address           = 127.0.0.1
Copy after login

This Will allow MySQL to accept connection requests from other computers. Save changes and exit the file.

Restart the MySQL service for the changes to take effect:

sudo service mysqld restart
Copy after login
  1. Create the MySQL database

Now, you have successfully installed MySQL on CentOS 6.5 and With this configured, we can create a new MySQL database. We need to enter the interactive shell of MySQL using the following command:

sudo mysql -u root -p
Copy after login

This will ask you to enter your MySQL administrator password. After entering your password, you will see the following command prompt:

mysql>
Copy after login

We need to create a new MySQL database. Execute the following command:

CREATE DATABASE mydatabase;
Copy after login

You can replace mydatabase with the name of the database you need to create.

  1. Create a new MySQL user

Now, we need to create a new MySQL user so that the database can be accessed. Execute the following command to create a new MySQL user:

CREATE USER 'myusername'@'%' IDENTIFIED BY 'mypassword';
Copy after login

Replace myusername and mypassword with the MySQL username and password you want to create, and remember these credentials.

We also need to assign permissions to the new user. Execute the following command:

GRANT ALL PRIVILEGES ON mydatabase.* TO 'myusername'@'%';
Copy after login

Replace myusername and mydatabase again with your MySQL username and database name.

  1. Security MySQL

To ensure the security of the MySQL database, we should delete the default MySQL user account and use a stronger MySQL password policy.

Delete default account:

DROP USER ''@'localhost';
DROP USER ''@'yourhostname';
Copy after login

Modify MySQL password policy:

SET GLOBAL validate_password_policy=LOW;
Copy after login
  1. Connect to MySQL

Now, you have successfully MySQL is installed on CentOS 6.5, and a new MySQL database and user have been created. You can use the following command to connect to a MySQL server:

mysql -u myusername -p -h IP地址 mydatabase
Copy after login

Replace myusername and mydatabase with the MySQL user and database names you just created. Replace IP address with the IP address of your CentOS 6.5 server.

If you successfully connect to the MySQL server, you have completed the process of installing MySQL on CentOS 6.5.

Conclusion

MySQL is a popular relational database that is often used as a backend for server-side applications. Installing MySQL on CentOS 6.5 is an important task as it is a popular server operating system. This article provides detailed steps to help you install MySQL on CentOS 6.5 and create a new database and user to be able to connect to the MySQL server and start using it.

The above is the detailed content of How to install mysql on centos6.5. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template