Discover mysql server remote access, include the articles, news, trends, analysis and practical advice about mysql server remote access on alibabacloud.com
MYSQL adds remote users or allows remote access.Add the remote user admin password as password grant all privileges on *. * TO admin @ localhost identified by \ 'password \ 'with grant option grant all privileges on *. * TO admin @ \ "% \"
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:
Install MySQL1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-5.1.7-0.i386.rpm
To download the above two RPM files, locate the "server" and "client programs" items and find the items
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
Mysql database, remote access to the current mysql database on the server, remote access, do not want to publish the root account, so, created a demo account, allow the demo account to access the shandong database in the mysql database
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
About MySQL user management, note 1, creating a new user after logging in by the root user creates >> grant all privileges on *. * to [email protected] Identified by "123456" ;//create a new user, the user name is TestUser, the password is 12345
In many cases, remote access to mysql is required, but the root user can only connect locally. To achieve remote access to the mysql database on your pc, you must open another account. First, run the mysql Command on MySQLServer to enter the mysql
The database is almost a right-hand person for the service-side developer. Almost every server-side developer has to deal with the database. and MySQL with its open source free, small and easy to use, powerful function of the Chinese database to
--------------------------------------------------------------------------------1 System settings:1.1 Remote Desktop settings: Through window settingsSystem--preferences--Remote DesktopTICK: Allow other users to control your desktopCancellation: You
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.