Add to MySQL in a super user, can any one access to the server machine

2010-04-19  来源:本站原创  分类:Java  人气:207 

GRANT ALL PRIVILEGES ON *.* TO root @ localhost
IDENTIFIED BY '12345678 'WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO root @ "%"
IDENTIFIED BY '12345678 'WITH GRANT OPTION;

相关文章
  • Add to MySQL in a super user, can any one access to the server machine 2010-04-19

    GRANT ALL PRIVILEGES ON *.* TO root @ localhost IDENTIFIED BY '12345678 'WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO root @ "%" IDENTIFIED BY '12345678 'WITH GRANT OPTION;

  • Quickly add multiple MySQL users and databases 2011-07-29

    If you like me love "move", they would understand that MySQL users and databases to add more pain. Previously with the virtual host, add in the cpanel, although there is a surface, the operation process is relatively simple and straightforward,

  • MySQL database solution method does not allow remote access from 2010-03-03

    Solution: 1, changing table method. Your account may be allowed from a remote landing, only localhost. This time as long as the localhost of that computer, log in MySQL , change " MySQL " database in the "user" table of "host"

  • mysql does not allow remote users to access the host server 1130 2010-07-12

    After installing connections to use mysql admin error ERROR 1130: Host ***.***.***.*** is not allowed to connect to this MySQL server Be found in the following Baidu, tried to Description of the user account is not connected to a remote connection pe

  • Access to the virtual machine (VM) on mysql 2010-10-19

    Recent study in the vm to do the exercises above install mysql Phenomenon: mysql installation is no problem, VM above can login mysql, Authorized to do, but also other machines (including my native) can not access the VM above mysql, tips that the IP

  • MySQL LIMIT in use (such as MS and ACCESS to TOP) 2010-11-02

    SELECT * FROM ORDER BY [COLUMN] (ASC | DESC) LIMIT [OFFSET], [RECNUM] Table [COLUMN] column name [OFFSET] starting position [RECNUM] the number of records that is, to identify the location from the counting of the RECNUM OFFSET records. If the table

  • Local access to remote (server) MySQL 2010-11-29

    Running: mysql-uAAtest-pAAtest-P3306-h123.123.123.123

  • mysql under linux notes 2011-08-07

    1 opening of the default installation of mysql remote access allows only local access, if access to other ip can be done about two steps: 1) Edit / etc / mysql / my.cnf comment out the following line bind-address = 127.0.0.1 2) open access to other i

  • mysqldump common statement and the arguments detailed 2010-07-12

    mysqldump client can be used to dump a database or collection of databases for backup or transfer data to another SQL server (not necessarily a MySQL server). Create table and load the dump contains the SQL statement table, or the entire database for

  • redhat5.2 environment to build the next freetds0.82 2010-11-05

    WEB under linux to do in the development of common environment is LAMP (Linux Apache Mysql Php), but sometimes, you may need to access Microsoft SQL Server database, then install freetds is usually done. There are many on the network and configure fr

  • configure php under windows environment 2010-06-21

    1, the php files to D: \ php-5.2.5 under 2, then open the "My Computer" -> "Properties" -> "Advanced" -> "Environment Variables" -> "System Variables" -> "path", edit the values be

  • Environment configuration under windows php 2010-06-21

    1, the php files to D: \ php-5.2.5 under 2, then open the "My Computer" -> "Properties" -> "Advanced" -> "Environment Variables" -> "System Variables" -> "path", edit the values be

  • Windows版Mysql5.6.11的安装与配置教程 2014-10-02

    这篇文章详细介绍了Windows下Mysql5.6.11的下载.安装与配置教程,需要的朋友可以参考下 注册了oracle的登录名:[email protected] 密码:dsideal******** 后面的*号是王卓常用的密码,但是是大写的,因为ORACLE的密码机制要求严格. WINDOWS版下载地址: 真实下载地址:http://cdn.mysql.com/Downloads/MySQLInstaller/mysql-installer-community-5.6.11.0.msi LI

  • Add remote root Mysql 2011-01-30

    Keywords: MySQL , create , super-user , remote After installing the MySql generally have only a super administrative user root, and root restriction can only be used on the machine in the database. We can add the following two ways a super administra

  • super administrator under windows mysql root password forgotten solution 2010-03-09

    Reprinted from: http://www.kuqin.com/database/20080306/4249.html Today to help a friend retrieve a MYSQL ROOT super administrator password, enter the command when starting a small punched a "point" harm's tossing a few hours, finally resolved, w

  • Apache2 + php5 + mysql under the windows installation and configuration diagrams 2010-02-16

    First ready software: Download the official Apache: apache_2.0.55-Win32-x86-no_ssl.msi , more versions here ; Download the official php: PHP-5.0.5-win32.zip , more mirror download address , more version of the download ; Download the official mysql:

  • MYSQL master-slave server configuration 2010-02-22

    windows under the master-slave configuration Achieve functional: A main server, B is from the server, the initial state, A and B in the same data, when A in the data is changed, B followed by corresponding changes also make the data A and B Informati

  • MySQL's configuration instructions 2010-02-24

    Installation First, select the type of installation There are three kinds of installation types available: Typical Installation (Typical), a full installation (Complete), and custom installation (Custom). Typical installation contains only the MySQL

  • Apache + php + mysql under the windows installation and configuration diagrams (change) 2010-04-14

    First ready software: Download the official Apache: apache_2.0.55-Win32-x86-no_ssl.msi , more versions here ; Download the official php: PHP-5.0.5-win32.zip , more mirror download address , more version of the download ; Download the official mysql:

  • MYSQL database to learn Daquan 2010-06-22

    MYSQL database is currently widely used in various personal, business systems, various technologies are relatively mature. Some of their own learning process to sum up, the contents of the article are not designed to do very specific set, only a simp