Discover grant select on database, include the articles, news, trends, analysis and practical advice about grant select on database on alibabacloud.com
Mysql database commands
Common MySQL commands
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
Linux mysql commands
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 restart (the
Connection: mysql-h host address-u user name-p user password (note: u and root do not need to add spaces, the same is true for others)Disconnected: exit (press enter)Create authorization: grant select on database. * to username @ login host
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 restart (the installation path of MySQL is
Install MySQL1. Download the MySQL Installation FileThe following two files are required to install MYSQL:
MySQL-server-5.1.7-0.i386.rpm To: http://dev.mysql.com/downloads/mysql/5.1.html, open this webpage and click"Linux x86 generic RPM
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
Transferred from: http://www.cnblogs.com/xiaochaohuashengmi/archive/2011/10/18/2216279.html1.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/
User management of the MySQL database user and log management database1.mysql user account management user account [email protected] Username: Account name host: Which client host requests this account can create connection threads, which can be IP,
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
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
MySQL database common commands we often useOne, connect MySQLFormat: mysql-h host address-u user name-P user Password1. Example 1: Connect to MySQL on this machine.First open the DOS window, and then enter the directory Mysqlbin, and then type the
http://blog.csdn.net/hanxin1987216/article/details/5976860First, summaryThe command to start MySQL under the 1.Linux system:Mysqladmin start/ect/init.d/mysql start (front of MySQL installation path)2.linux Restart MySQL command:Mysqladmin
Recently in learning MySQL, or only rookie, find the following article for beginners very useful, so share under1.linux commands to start MySQL:Mysqladmin start/ect/init.d/mysql start (front of MySQL installation path)2.linux Restart MySQL
Reprint: http://www.cnblogs.com/xiaochaohuashengmi/archive/2011/10/18/2216279.html1.linux commands to start MySQL:Mysqladmin start/ect/init.d/mysql start (front of MySQL installation path)2.linux Restart MySQL command:Mysqladmin
Transferred from: http://www.jb51.net/LINUXjishu/36171.htmlFirst, summarize: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
Connection: mysql-h host address-u user name-p User Password (Note: u and root do not need to add spaces, the same is true for others)Disconnected: exit (Press ENTER)
Create authorization: grant select on database. * to username @ login host
I. Summary:
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 restart (the installation path
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 restart (the installation path of MySQL is
1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-4.0.23-0.i386.rpmMySQL-client-4.0.23-0.i386.rpmTo: http://www.mysql.com/downloads/mysql-4.0.html, open this webpage and pull down the webpage
Connection: mysql-h host address-u user name-p User Password (Note: u and root do not need to add spaces, the same is true for others)Disconnected: exit (Press ENTER)
Create authorization: grant select on database. * to username @ login host
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.