Get the App
SLTechnology News&Howtos  ›  Database  › 

How to connect to MYSQL remotely

Shulou Source: shulou.com Published: 2022-05-31 15:56:04 11月21日 Update

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.

Tags: Articles data databases more good practical content articles users knowledge empowerment reference help related Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Microsoft Redmi MySQL Shulou Information