grant select on database

1. MySQL Common commands Create Database Name; Create a database Use databasename; select database Drop database name directly deletes the database, no reminder Show tables; displays tables Describe tablename; Detailed description of the table Add

MySQL installation test After installing MySQL, you also need to test it to determine whether MySQL is successfully installed. The visualization of MySQL is different from that of SQL Server. There are two test methods for MySQL: 1. Test using MySQL

Test environment: MySQL 5.0.45 [Note: You can use MySQL> select version (); in mysql to view the database VERSION] 1. Connect to MySQL. Format: mysql-h host address-u user name-p User Password 1. Connect to MySQL on the local machine. First open the

I. Summarize some MySQL commands in Linux: 1. commands for starting mysql in Linux:Mysqladmin start/Ect/init. d/mysql start (the installation path of mysql is earlier) 2. Command for restarting mysql in Linux:Mysqladmin restart/Ect/init. d/mysql

To use Linux and MySQL, you must be familiar with Common commands. The following are some common commands collected: 1. commands for starting mysql in linux:Mysqladmin start/Ect/init. d/mysql start (the installation path of mysql is earlier)2.

1. Check the database version SQL> status; 1. net start mysql // start the mysql Service 2. net stop mysql // stop mysql Service 3. mysql-h host address-u user name-p User Password // enter the mysql database 4. quit // exit mysql 5. mysqladmin-u

I. Common commandsList databases: Show databases;Select Database: Use databasename;List tables: show tables;Create Database library name;Create Table Name;Display the data table structure: DESC table name;Delete database drop database database

1. Connect to MySQL. Format: mysql-H host address-u user name-P User Password 1. Example 1: connect to MySQL on the local machine. First, open the DOS window, enter the directory mysqlbin, then type the command mysql-uroot-P, and press enter

I. MySQL connection format: Mysql-H host address -U User Name -P User Password 1. Example 1: connect to MySQL on the local machine: First, open the DOS window, enter the directory mysqlbin, then type the command mysql-uroot-P, and press enter to

MySQL beginner's guide and introduction 1. Connect to MySQL.Format: mysql-H host address-u user name-P User Password1. Example 1: connect to MySQL on the local machine.First, open the DOS window, enter the directory mysqlbin, then type the command

1. Connect to MySQL. Format: mysql-H host address-u user name-P User Password1. Example 1: connect to MySQL on the local machine.First, open the DOS window, enter the directory mysqlbin, then type the command mysql-uroot-P, and press enter to prompt

Document directory 1.1 connect to MySQL 1.2 change New Password 1.3 new users added 1.4 Start and Stop MySQL 2.1 database operations 2.2 table operations 3.1 export database files from a database 3.2 importing data from external files to

Actual Operation (I think it is also a simple method ): I installed MySQL some time ago, but if I had some problems, I wanted to uninstall it and reinstall it. However, I did not expect to uninstall the software in Linux.My MySQL is installed using

  1) connect to MySQL: Format: mysql-H host address-u user name-P User Password 1. Example 1: connect to MySQL on the local machine Mysql-uroot-P. Press enter and you will be prompted to lose the password, If you have just installed MySQL,

Mysql database operation statement and mysql statement Mysql format statement SpecificationHow to log on to your database?Example!If it is the cost of compilation and installation, you have to go to the directory after compilation and installation.

Install mysql in centos5.8 1. Install mysql yum Source Download the rpminstallation package of mysql's latest yumsource from http://dev.mysql.com/downloads/repo/yum/   wget http://repo.mysql.com//mysql57-community-release-el6-9.noarch.rpm Use yum

MySQL databases can be said to be one of the most common and common databases for DBAs. The wide application of MySQL also adds more people to the ranks of them. The following are some of the most common and frequently used MySQL Databases

Mysql common command Collection [absolute essence] bitsCN.com 1. connect to MYSQL. Format: mysql-h host address-u user name-p user password 1. connect to MYSQL on the local machine. First open the DOS window, then enter the directory mysql/bin,

This article summarizes some suggestions about how to add SQL statements for new MySQL users. This article summarizes some suggestions about how to add SQL statements for new MySQL users. Format: grant select on database. * to username @ login

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 lose the password.