grant select on database

MySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/bin (Mysqladmin mysqldump and other commands)Startup scripts/etc/init.d/mysql (startup

0. Start and stop of MySQL servicenet stop MySQLnet start MySQL1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then

Transferred from the public number "MySQL database": http://mp.weixin.qq.com/s?__biz=MzIyNjIwMzg4Ng==&mid=2655293044&idx=1&sn= E312934e5115105fdbe5da12af150276&scene=0#wechat_redirect"All over" MySQL database operations common commands2016-07-21

3. Add Users:(Note: Unlike the above, the following is because it is a command in a MySQL environment, so it is followed by a semicolon as a command terminator)Format: Grant Select on database. * To User name @ login host identified by "password"The

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

0. Display Databaseshow databases;1. Select DatabaseUse database name;2. Display the tables in the databaseShow tables;3, display the structure of the data tabledescribe table name;4. Display the records in the tableSELECT * from table name;5. Build

http://blog.chinaacc.com/garfiled606/blog/20100119-1909060539272.html Client connections:Go to command line, Windows cmd, connect:Mysql-u User name-p password-H server IP address-P server-side MySQL port number-D database nameAttention:(1) Server

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

1.linux commands to start MySQL:Mysqladmin start/ect/init.d/mysql start (front of MySQL installation path)2.linux Restart MySQL command:Mysqladmin restart/ect/init.d/mysql Restart (front of MySQL installation path)3.linux the command to turn off

First, MySQL commonly used statementsCreate, delete, and most basic queries:Display database mysql->show databases;Create DATABASE Mysql->create db;Delete database Mysql->drop db;Select Database Mysql->use dbCreate Tables Mysql->create table MyTable

Table OperationsNote: You should connect to a database by using use before the operation.Build tableCommand: CREATE table ( [,.. ]);Example:Mysql> CREATE TABLE MyClass (> ID int (4) NOT null primary key auto_increment,> Name char () NOT NULL,>

1, problem one: Use update mysql.user set password= ' root ' change password, cannot log inWORKAROUND: The operating procedure is as follows.(1) Close MySQL (Kill the mysqld process), then use the command:Mysqld--skip-grant-tables(2) Start the

MySQL Common commandsMySQL installation directoryDatabase directory/var/lib/mysql/Configuration file/usr/share/mysql (mysql.server command and configuration file)Related commands/usr/bin (Mysqladmin mysqldump and other commands)Startup

Note: Each command in MySQL is followed by a semicolon;1. Display Databasemysql> show databases;+----------+| Database |+----------+| MySQL || Test |+----------+2 rows in Set (0.04 sec)MySQL has just finished installing a database of two databases:

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

 MySQL's dos command line DaquanTags: dos command line2016-11-04 16:03 509 people read comments (0) favorite reports Classification:DOS command line (5)MySQL (1)Directory (?) [+]1, connect MySQL (Chinese garbled at the end of the article) format:

the command to log in to MySQL is mysql: mysql [-u username] [-h host] [-p[password]] [dbname] MySQL directory:Database directory:/var/lib/mysql/Configuration file:/usr/share/mysql(mysql.server command and configuration file)Related

MySQL Format statement specificationHow do I log into your database?Example!If you are compiling the installation of the flowers, then you have to compile the installation of the directory to go, my is installed into the/usr/local/mysql database: Cd/