Create a new user under 1,mysql
Grammar:
1.create user username identified by ' password ';
Example: Create user Xiaogang identified by ' 123456 ';
The newly created user, by default, does not have any permissions.
2. How to assign permissions
The mysqld_safe that uses the binary compilation file starts the error as follows:
[MYSQL@ECP-UC-DB1 ~]$ Mysqld_safe110707 21:31:19 mysqld_safe Logging to '/opt/mysql/mysqldata/ecp-uc-db1.err '.110707 21:31:19 Mysqld_safe the
The number of connections exceeds the value set by MySQL and is related to both max_connections and wait_timeout. The larger the value of the wait_timeout, the longer the idle wait for the connection, which causes the current number of connections
MySQL to add new users can be done in two ways:
1. By way of the grant statement, we will explain this in the MySQL permissions below, which is simply an example.2. Direct operation of the MySQL authorization form (this method is now basically not
1. First in the C disk we create a TXT document renamed it "Mysql-init.txt", the contents of the document we enteredUpdate Mysql.user set Password=password (' newpasswd ') where user= ' root ';
Flush privileges; Note: One of the newpasswd can be
Sub-table
1, do MySQL cluster, for example: Use MySQL cluster, MySQL proxy,mysql Replication,drdb and so onSome people will ask MySQL cluster, what is the relationship between the root table? Although it is not in the actual sense of the table, but
Specific methods
Before deleting a log, check the log files currently used by the master-slave server.
First log on the MySQL terminal of the server to which you want to delete logs#mysql-U root-pxxxxx
Check Replication master server
Char type
The length of the char column is fixed to the length declared when the table was created. The length can be any value from 0 to 255. When you save the char value, fill the space on their right to reach the specified length. When a char
Error tips
Is the Chinese all display garbled
Resolution method
Query MySQL Settingsmysql> s--------------C:Program filesmysqlmysql Server 5.0binmysql.exe Ver 14.12 distrib 5.0.67,For Win32 (IA32)Connection id:1Current Database:commonCurrent User:
Error occurred while I was performing insert ABC (a) VALUES (' Bfdsafdsafdsafdsa ') : #1264-out of Range value adjusted for column ' A ' at row 1
Cause analysis
We see it in English because the length of the field is not enough
Solutions
Modify
If a table product has a field add_time and its data type is datetime, someone might write SQL like this:
The code is as follows
Copy Code
SELECT * FROM product where add_time = ' 2013-01-12 '
For this
First with the root account login phpMyAdmin, and then click on the left to enter the MySQL database, at the top of the click "MySQL" into the SQL input interface. Enter the following command:
The code is as follows
Copy Code
0. Environment
Ubuntu 12.04 x64 Server
MySQL 5.5.29
1. Steps
1.1 Modify your MySQL ' s "my.cnf" file, and add a line in "[Mysqld]" session:Skip-grant-tables
1.2 Restart MySQL
1.3 Log in MySQL without password$ bin/mysql-u Root-pPress ENTER
installing MySQL
The screenshot used is the MySQL 5.5 installation process, and 5.6 not much difference.
1. Confirm the installation of the Microsoft. NET Framework v4.0 Framework
The following illustration suggests:
If the. Net Framework
Htmlspecialchars
Converts special characters into HTML format.
Syntax: string Htmlspecialchars (String string);
return value: string
function Type: data processing
Content
After/etc/init. d/mysql start is started, the error message is as follows: The code is as follows:Copy code Can't find file: "./mysql/plugin. Frm' (errno: 13)[ERROR] Can't open the mysql. plugin table. Please run mysql_upgrade to create it. An
Install mysql from ubuntu today The code is as follows:Copy code Apt-get install mysql-server Found at startupService mysql startRather than invoking init scripts through/etc/init. d, use the service (8)Utility, e.g. service mysql start Since
First, go to Synaptic Package Manager. If not, download it from Ubuntu Software Center;Search for apache2, php5, and mysql in sequence.Select apache2. Other dependencies and subitems are automatically selected.Search and select php5Search and check
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service