If the root password is not set during installation, you can directly press Enter when logging on using the MySQL command line tool.
However, you must set a password when connecting some tools. The simplest method:
Go to the bin directory of the
1 error 2002 (hy000): Can't connect to local MySQL server through socket '/var/lib/MySQL. Sock' (2)
MySQL not started
2 error 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: No)
The password is incorrect. Modify the
1. startup MethodSwitch to the bindirectory of the mysqlinstallation directory and execute mysqld.exe2. Close MethodExecute mysqladmin.exe-H localhost-u root Shutdown
3. Authorize a Database UserGrant select, insert, update, delete on Blog. * to
This article attempts to describe the optimal selection from the perspective of the schema and index created by the data table. Optimal Data Types
The smaller the data, the better. Select the minimum data type that meets your needs. By saving
MySQL supports regular backup using MySQL administrator in windows, which is troublesome in Linux, if there is no ready-made product, you can only write it by yourself. 1. Create a MySQL. Sh file and enter ! /Bin/sh # backup MySQL database #
Operating Environment: fedora13; mysql5
Modify the MySQL password format in Linux as follows:
Mysqladmin-u Username Password newpassword
Eg:
Mysqladmin-u Root Password mynewpassword;
Chinese garbled characters
Create users and user groups firstSu-RootGroupadd MySQLUseradd-G MySQL decompress the binary file.Tar zxvf mysql-5.0.51a-linux-i686.tar.gzCopy the directory/home/MySQL to/usr/local. Create the MySQL license table:[Root @ localhost root] #
The problem is: There are two tables, one is to record the records of yesterday and the other is to record the records of today.
(1) Newly Added records: There are records today, not yesterday;
(2) reduced records: there are no records today, and
Guidance:1. back_logSpecify the number of possible MySQL connections. When the MySQL main thread receives many connection requests in a short time, this parameter takes effect. Then the main thread takes some time (although very short) to check the
MySQL version used: mysql4.0.x
MASTER: 192.168.1.102SLAVE: 192.168.1.109
Modify C:/winnt/My. ini for Windows host. Modify/etc/My. CNF for Linux host.
1. Master operations1. modify my. ini##############Server-id = 1Log-bin =
To install MySQL, run the following command at a terminal prompt:
Sudo apt-Get install mysql-Server
Sudo apt-Get install mysql-Client
Sudo apt-Get install php5-mysql// Installing the php5-mysql is to connect PHP and MySQL
Once the installation
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
This article introduces the database index, and its advantages and disadvantages. The features and applications of MySQL indexes are described in detail. This article analyzes how to avoid MySQL unavailability, how to use explain to analyze query
1. log on to the mysql monitor command: cmd>Mysql-u root-pThen press enter to enter the password
2. the mysql configuration file is my. ini under the installation directory.
The slave database crashes directly, and the root user cannot log in.
Redhat
LinuxSimple installation and configuration of PHP5 + MySQL5 + GD2 + Proftpd + phpmyadmin
I always wanted to write an article about Linux
PHPDetailed installation and configuration documents of the environment, no time
I would like to take the
1. Benchmark Test and Performance Analysis
Benchmark Testing and performance analysis are two basic methods for identifying system bottlenecks:
The benchmark test is used to measure the overall performance of the system. This helps to determine the
Create procedure, Create function
Below are their formats:Create proceduresp_Name ([proc_parameter])Routine_body
Here, the parameter type can be in out inoutt, which means the same as the word, and IN indicates the passed parameter,"OUT" indicates
During busy periods, the new server and app will be renewed. In addition, many configurations will be changed when the company moves at the end of the month.In the morning, when you do not want to change the dns via telnet, it is found that the
Mysql has a function to log down and run slow SQL statements. This log is not available by default. To enable this function, modify my. cnf or add some parameters when mysql is started.
If you modify it in my. cnf, add the following
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