How to enable the MySQL database remote access permission (two methods), mysql Remote Access
Download and install GPL
MySQL Community Edition (GPL)
Community (GPL) Downloads»
When we use the mysql database, sometimes our program and database are not
I. Windows environment 1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysq on the computer of localhost.
I. Windows environment 1. Change the table.
I. Windows Environment 1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user"
First, turn on the Mys remote access function1. Enter the server input Netstat-an | grep 3306 confirms that 3306 is open to the outside, MySQL default state is not open access function. If the port is not open after entering the above command, it
This article mainly introduces how to install MySQL and enable MySQL remote access in CentOS, including the introduction of MySQL random start and other operations. For more information, see
Install MySQL
Install MySQL and php-mysql
[root@sample ~]
Guide for building the JavaEE environment on the CentOS server (Remote Desktop + JDK + Tomcat + MySQL) and centosjavaee--------------------------------------------------------------------------------1. system settings:1.1 remote desktop settings:
Reference blog:Linux Learning CentOS (13) installation and configuration of MySQL database under--centos6.4MySQL multiple ways to change the root passwordBackup and restore of MySQLTroubleshoot MySQL import restore when the problem is garbledMySQL
By default, MySQL cannot be accessed through a remote machine. The following configuration allows you to enable remote access.
On the MySQL server:
Run the MySQL command to enter the MySQL command mode,SQL code
Mysql> use MySQL;
Mysql> grant
Install MySQL in CentOS and enable MySQL remote access. centosmysql
Install MySQL
Install MySQL and php-mysql
[root@sample ~]# yum -y install mysql-server [root@sample ~]# yum -y install php-mysql
Configure MySQL
[Root @ sample ~] # Vim/etc/my.
Enable MySQL remote access permission to allow remote connection to bitsCN.com
1. log on to the mysql database
Mysql-u root-p
View user table
Mysql> use mysql;Database changedMysql> select host, user, password from user;+ -------------- + ------ +
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.