Copy Code
Grant USAGE on *.* to ' username ' @ ' localhost ' identified by ' password ' with GRANT OPTION;
Last sentence:
Replace "username" with the user name to be authorized, such as CLIENTUSR;
Replace "password" with the password set by CLIENTUSR;
4, Access to data table authorization
After the account is created, the common user is given the data table authorization, the additional connection user default permissions in step 3 are "N", the account must be auth
effective, which is why the subquery is often converted to a connection query, and the optimizer has been able to handle the connection query correctly, and of course it is important to ensure that the connection column (second table) of the connection table is indexed, On the first table MySQL usually scans the entire table relative to the query subset of the second table, which is part of the nested loop algorithm.
. View warning information
Before viewing the warning information, let's look at an example of creating a database:
Create database t1;
Create database if not exists t1;
IF a table with the same name as the table to be created EXISTS, the current table will NOT be created.
Yes. This is the syntax of if not exists. NOT creating a table is NOT an error, but is one of the normal execution results of this statement.
So now we need to view the warning information. The syntax format is:
Show warnings
\', and the absolute path to be exported must be enclosed by '. Therefore, it hurts ..2. when there is no read/write permission, you can determine the MySQL version. If MySQL 5.0 or above is used, you can obtain the username and password. If MySQL 5.0 or above is used, the password cannot be cracked (for example, the information_schema database is restricted ),
Tags: database mysql SuSEFor MySQL in rpm mode under Linux, we can remove these rpm packages and delete the items directory to achieve the purpose of uninstallation. This article demonstrates downloading MySQL 5.5.37 under SuSE Linux 10. See below for details.1. Environment#OS环境szdb:~ # Cat/etc/issueWelcome to SUSE Linux Enterprise Server SP3 (x86_64)-Kernel \ R
RestartThen check the running status of MySQL and see:: 3306 I'm relieved, alas, I'm a little tired now.[Email protected]:/# netstat-antupThen create the required database and simply manipulate the database.1. Enter the database[Email protected]:/#mysql-u root-penter Password: (Enter password)Welcome to the MySQL Monitor. Commands End With; or \g.your
/index.php ? Username=yao Userpwd=123456#top ? before is the file name. ? followed by a query string. query string:? username=yaouserpwd=123456//location.search after the query string, it is the anchor name. such as:#top 3.Header () L Description: send a custom http message , in other words:the format or character set of the data returned by PHP. L Syntax:void Header (string $string) L Example: U header ("Content-type:text/html;charset=utf-8")// set The character set of PHP return data U hea
EXISTS] db_name; Example: Take a look at the list of databases on the server before deleting them: SHOW DATABASES; We will create the database T2 Delete and view the database list again DROP DATABASE T2; SHOW DATABASES; Seven entering the database The syntax format for entering a database in the MySQL service is: Use db_name; Select the MySQL database that you want to manipulate, and all
My experiences with MYSQL (1)
My experiences with MYSQL (2)
My experiences with MYSQL (III)
My experiences with MYSQL (4)
There are many operators in MYSQL. This section mainly describes some operators in MYSQL, but not those in
There is a function in mysql5.x for Linux that can help us do a lot of things, this function 4. X below does not seem to have been found, and I did not check the function manual. I just wrote something in my own experience. 4. Let's take a look at the function manual tomorrow for another experiment.
MySQL 5. X introduces a system function. This function can execute system commands. when
' new_password ' //123 for old password method two: UPDATE mysql.user SET password= Password (' new_password ') WHERE user= ' root ' and host= ' localhost '; FLUSH privileges; method Three: SET password=password (' New_password '); FLUSH privileges;Root to modify other user passwords:Method One: SET PASSWORD for user name @ ' IP address ' =password (' new_password '); FLUSH privileges; method Two: UPDATE mysql.user SET password=password (' New_password ')
The following articles mainly solve the problems encountered during MySQL 5 installation. This article mainly analyzes the problems related to MySQL 5 installation in code mode, if you are interested in the actual operations, you can browse the following articles.
1. [root @ localhost bin] #./MySQLd_safe-skip-grant-tab
char (NOT NULL),> Sex int (4) NOT null default ' 0 ',> Degree double (16,2));2. Get the table structureCommand: DESC table name, or Show columns from table nameMysql>describe MyClassmysql> desc MyClass;Mysql> show columns from MyClass;3, delete the tableCommand: DROP table For example, to delete a table named MyClassmysql> drop table MyClass;4. Inserting dataCommand: INSERT into For example, insert two records into table MyClass, two records that say
Label:PHP operation MySQL database generally can be divided into 5 steps: 1. Connect to the MySQL database server, 2. Select the database, 3. Execute the SQL statement; 4. Close the result set; 5 disconnect from the MySQL database server.1. Connect the
1. MySQL has multiple rows that access tables. The most commonly used rows are sequential access and index access. Sequential access refers to browsing a table in one row, that is, full table scan. Disadvantage: It is very time-consuming and inefficient. Index access: Read Only the rows that show the required features, including at least one index, similar to the directory in the book. Www.2cto.com index: a list containing the value of the index field
5. sort and retrieve data
5.1 sort data
ORDER
SELECT prod_name FROM products ORDER BYprod_name; // sort search
SELECT prod_id, prod_price, prod_name
FROM products ORDER BYprod_price, prod_name; // sort by multiple columns
5.2 specify the sorting direction
DESC sort in descending order
SELECT prod_id, prod_price, prod_name FROMproducts order by prod_price DESC; // sort in descending ORDER
SELECT prod_id, prod_price, prod_name FROMproducts order by prod
|2|| Lily | F |3|| Lucy | F |4|| Travis | M |5|| Steve | M |6|+--------+-----+------------+6RowsinchSet (0.00sec) MySQL > Delete fromStudentwheresex='F'; Query OK,2Rows Affected (0.01sec) MySQL > Select*from student;+--------+-----+------------+| name | sex | student_id |+--------+-----+------------+| Jim | M |1|| Tom | M |2|| Travis | M |
An error occurred when using MySQL 5.x or a later version #1929 Incorrect datetime value: '''' for column ''createtime,
After MySQL is installed, an error message indicating #1929 Incorrect datetime value: ''for column 'createtime' is always displayed when saving and deleting table data. As a result, the table data cannot be deleted;
Cause analysis:
Deployment of Ubuntu12.0.4Linux server: modifying MySQL character set 5.x Ubuntu
Go to the mysql installation directory and find the configuration file,/etc/mysql/my. cnf
Run the following command:
sudo vi my.cnf
Go to the modify configuration file,
1-under the [client] Node, add
# The default character set is utf
internet. With phpMyAdmin, you can fully manipulate the database, such as setting up, copying/deleting data, and so on.4. Mysql-frontA small app for managing MySQL. Main features include multi-document interface, syntax highlighting, drag-and-drop database and table, editable/Add/remove fields, editable/pluggable/deleted records, can display members, executable SQL scripts, provide interface with external
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.