Linux under MySQL operation command One, 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 command
Sqlplus How to connect to a database1> cmd input: sqlplus user name/password @ DB instancesuch as: Sqlplus System/[email protected],Sqlplus Sys/admin as Sysdba2> Open Sqlplus Enter your username and password directly3> use command: Connect sys/admin
Linux mysql Operations Command1.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
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
Where the user manages user data:All users in MySQL are stored in the user table in the system database (MySQL)--regardless of which database users are stored here.The initial contents of the table are as follows:To create a user:Form:Create user '
Grant added MYSQL user 2009-04-03 14:40I installed the version:Mysql> select version ();+------------+| Version () |+------------+| 5.0.22-log |+------------+1 row in Set (0.05 sec)Add Users:Mysql> Grant Select,update,insert,delete on * * to [E-
Idea: Uninstall Redhat with yum, then download the CentOS yum, install and modify the configuration file1 , first to Http://mirrors.163.com/centos Download Packagex86 Address: http://mirrors.163.com/centos/6/os/i386/Packages/x86_64 Address:
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
The default user has root Super Administrator, to make a website, to connect MySQL to a user name and password, can not be root, prevent misoperation. MySQL service can run multiple libraries, so you need to give individual users some authorization,
Turn from http://www.cnblogs.com/yjhrem/articles/2340149.htmlRun the cmd command lineInput sqlplus/nolog no user name loginConn/as SYSDBA Connect to data Local dataAlter user system identified by password; Modify the system password to
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
This article by show according to Lin Feng to provide friendship sponsorship, starting in the mud row World . 1 , the format of the connected database Mysql-h ip-u user name-p password; 1.1 connecting to a remote database Mysql-h 192.168.1.214-uroot-
Reprint Please specify source: http://blog.csdn.net/l1028386804/article/details/46763767In the MySQL database, there are mysql_install_db scripts to initialize the permissions table, and the tables that store the permissions are:1. User table2. DB
Common MySQL operation and maintenance commands
1. Change Password:
Mysqladmin-u root-p password New password
Enter the old password.
2. Export the entire database:
Mysqldump-u username-p Database Name> exported file name
3. Import the database:
Go
I. Windows environment 1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysq on the computer of localhost.
I. Windows environment 1. Change the table.
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.