mysql remote access and authorization

2010-05-01  来源:本站原创  分类:Database  人气:230 

Related articles:
Installation mysql5.1 (linux (red hat 3))
I see pros and cons of Spring Security

Recommended circle: rights management for more recommended [MYSQL] to create a remote login user and authorize Database 2009-04-29 14:07:01 268 Comments 0 read font size: large, medium and authorized users to create a remote login> grant all PRIVILEGES on discuz. * to ted @ '123 .123.123.123 'identified by '123456'; the above statement that the database will discuz ted all the rights licensed to the user, allowing users to 123.123.123.123 the IP ted remote login, and set the user's password ted is 123456.

The following analysis of all the parameters one by one:

all PRIVILEGES that all of the privileges granted to authorized users, there can also be replaced to give a specific authority, such as: select, insert, update, delete, create, drop, etc., between the use of specific rights, "" comma-separated.

discuz .* that the above permission which is against the table, discuz refers to the database, the latter * that for all of tables, it can be inferred that: For all databases for all of tables authorized "*.*", a database of all the tables authorized "database name .*", a table for a database license for the "database name. table name."

ted that which you give the user authorization, the user may be existing users, can also be non-existent users.

123.123.123.123 that allow remote connection IP address, if you want no restrictions on the IP link is set to "%" can be.

123456 for the user's password.

Implementation of the above statements, then execute the following statement before effective immediately.

> Flush privileges;

相关文章
  • mysql remote access and authorization 2010-05-01

    Related articles: Installation mysql5.1 (linux (red hat 3)) I see pros and cons of Spring Security Recommended circle: rights management for more recommended [MYSQL] to create a remote login user and authorize Database 2009-04-29 14:07:01 268 Comment

  • mysql remote access settings (reproduced) 2011-06-14

    After landing, run the following command to give the remote access client privilege .. grant all on *.* to 'remote' @ '172 .16.21.39 'identified by' password '; said remote user name. '172 .16.21.39 'Remote ip address password that a remote login pas

  • MySQL remote access settings 2010-06-17

    Mysql Remote Access on more articles, mostly to set MYsql main. I use Mysql 5.1.40 on Windows xp Here are the main two stages set up remote access to it The first step to set Mysq remote access, methods such as setting the mysql many ways than that o

  • Ubuntu Open MySQL remote access function 2011-10-19

    Confirm whether the 3306 opening, MySQL default is not open external access function. See the following ways: netstat -an | grep 3306 Display the results :tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN As can be seen from the above, mysql is listening to po

  • linux mysql remote access 2011-05-24

    In order to run a real server environment, network deployed today, including a Ubuntu Linux server, one of the most troublesome is the mysql installation, apt too slow to download updates, so to compile a bit on the mysql source code, can refer to th

  • MYSQL remote access solutions and analysis of slow 2011-01-25

    Problems of the scene: MYSQL installed on Linux, both local and remote application access MYSQL, MYSQL very smooth local access, but remote access is very slow, basically only a few minutes to respond to the point. SSH connection stability, ping the

  • MYSQL remote access solution 2010-07-27

    mysql -h 192.168.0.222 -uroot -proot If you want to connect to your mysql when this error occurs: ERROR 1130: Host '192.168.0.222' is not allowed to connect to this MySQL server Solution: 1. Change table method. Your account may be allowed from a rem

  • Mysql remote access under Ubuntu 2010-11-11

    1, install mysql sudo apt-get install mysql-server mysql-client The middle will prompt you to enter a password, the default action for the rest of the line 2, open terminal, log in mysql mysql-h localhost-u root-p Prompt access password to login 3, c

  • MySQL on Linux, remote access capabilities 2011-04-04

    (1) confirm whether the 3306 opening, mysql default is not open to outside access to functions. See the following ways: Java code ~ # Netstat-an | grep 3306 tcp 0 0 127.0.0.1:3306 0.0.0.0: * LISTEN As can be seen from above, mysql port 3306 is listen

  • Set Remote Access Mysql 5.1.40 2010-03-26

    Mysql Remote Access on more articles, mostly to set MYsql main. I use Windows xp Mysql 5.1.40 Here are the main two stages set up remote access to it The first step <br /> set Mysq remote access, methods such as setting the mysql many ways than that

  • Close / restrict the user remote access permissions MYSQL 2010-10-02

    Because it involves a convenient reasons, MYSQL remote access permissions to the specified user opens, and by updating the user table in mysql database field value corresponding to that, and in the establishment of the database, give the remote acces

  • A remote access solution to mysql error 2011-04-16

    A remote access solution to mysql error Tags: MySQL , remote access Today in the configuration of a server, how Rom this server mysql. Telnet normal in this machine to access your mysql properly. Error SQL Error (2003): Can't connect to MySQL server

  • mysql remote connection settings mysql remote connection settings 2010-06-09

    y default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server. MySQL Remote Access You need type the following commands which will

  • Set mysql for remote access 2010-08-23

    System running on linux systems, remote control database is necessary, enter the mysql [Root @ localhost /] # mysql-uroot-p password :****** mysql> select user, host from user where user = 'root' +------+-----------------------+ | user | host | +----

  • MySQL database can not remote access solution 2010-11-12

    MySQL database can not remote access solution :2008-04-09 Views: 1165 MySQL database does not allow remote access from how to do? This article provides three solutions: 1, change the form method. Your account may be allowed from a remote landing, onl

  • MySQL database remote access solution can not be 2010-11-12

    MySQL database can not remote access solutions :2008 -04-09 Hits: 1165 MySQL database does not allow remote access to how to do? This article provides three solutions: 1, change the table method. Your account may be allowed from a remote landing, onl

  • mysql remote connection and access solutions to slow 2011-05-23

    Reserved 1: Today's networks have been adjusted, resulting in the original fast mysql server connection, the connection is excruciatingly slow. Tens of milliseconds before a connection is now nearly 5 seconds to complete one to the exclusion of the n

  • How to remote access MySQL server 2010-09-09

    How to remotely access MySQL server? In the MySQL Server side: Implementation of the mysql command to enter mysql command mode, CODE: mysql> use mysql; mysql> GRANT ALL ON *.* TO admin @ '%' IDENTIFIED BY 'admin' WITH GRANT OPTION; # This is meant t

  • Linux iptables open port to allow remote access to Mysql 2010-10-16

    Linux iptables open port to allow remote access to Mysql Modify the firewall configuration file: vi / etc / sysconfig / iptables Add the following line: -A RH-Firewall-1-INPUT-m state-state NEW-m tcp-p tcp-dport 3306-j ACCEPT If you want to open port

  • Set mysql root access remote connection 2010-12-08

    Mysql remote connection when it should have come across, root user can not remotely connect mysql, with only local, foreign rejected the connection. Need to establish a database to allow remote login account, so that it can operate in the remote data