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

This article will explain in detail how to connect MYSQL remotely. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Start MYSQL

[root@zhangruiu1 ~] # mysqld_safe &

[1] 39558

[root@zhangruiu1 ~] # 160520 20:40:35 mysqld_safe Logging to'/ var/log/mysqld.log'.

160520 20:40:35 mysqld_safe Starting mysqld daemon with databases from / var/lib/mysql

[root@zhangruiu1 ~] # ps-ef | grep mysql

Root 43541 33110 0 21:41 pts/1 00:00:00 / bin/sh / usr/bin/mysqld_safe

Mysql 43609 43541 0 21:41 pts/1 00:00:00 / usr/libexec/mysqld-basedir=/usr-datadir=/var/lib/mysql-user=mysql-log-error=/var/log/mysqld.log-pid-file=/var/run/mysqld/mysqld.pid-socket=/var/lib/mysql/mysql.sock

Root 43886 43852 0 21:43 pts/3 00:00:00 grep mysql

[root@zhangruiu1 ~] #

Create a database

[root@zhangruiu1 ~] # mysql

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 1

Server version: 5.1.66 Source distribution

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

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

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

Mysql > show databases

->

+-+

| | Database |

+-+

| | information_schema |

| | mysql |

| | test |

+-+

3 rows in set (0.01sec)

Mysql > create database r7_mysql character set GBK

Query OK, 1 row affected (0.01sec)

Mysql > show databases

+-+

| | Database |

+-+

| | information_schema |

| | mysql |

| | r7_mysql |

| | test |

+-+

4 rows in set (0.00 sec)

Create a user

Mysql > use r7_mysql

Database changed

Mysql > CREATE USER 'r7' identified by 'r7'

Query OK, 0 rows affected (0.14 sec)

You need to be empowered if you need to connect to the database remotely.

Mysql > GRANT ALL ON *. * TO 'r7'

Query OK, 0 rows affected (0.08 sec)

This is the end of the article on "how to connect MYSQL remotely". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.