Since an import process was roughly interrupted in September 30, I found that MySQL could not be started, so I had to uninstall and reinstall it (maybe it may take some time to find the problem, but it is faster ). When the import process is
Respect for personal work. If the record is reprinted, indicate the source. Iihero @ csdn
Some of my friends asked me what is the difference between this non-installed version and the installed version (of course, it is a Windows platform)
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
Mysql-uroot-P. Press enter and you will be prompted to lose the password,
If you have just installed MySQL,
We need to make an urgent request today,Algorithm4 million of the data is calculated (only Nick is included), and a customized database needs to be imported.
32 databases on MySQL (icluster_1 to icluster_32, calculate the remainder Based on
According to the definition, the database management system aims to manage data. Even a simple select 1 Statement involves an expression evaluate to generate an integer data value. Each data value in MySQL has a type. For example, 37.4 is a number,
Document directory
1. Download the MySQL 5.5 Deb installation package
2. Install the Deb package
3. Enabling MySQL
1. Download the MySQL 5.5 Deb installation package
CD/usr/local/src
Sudo wget-O mysql-5.5.22-debian6.0-i686.deb
When developing a project, you may encounter a problem: You must Randomly Read some records of a table and set update to unreadable, multiple people may randomly perform the same record at the same time and perform the update operation again,
1. Try your best to use SQL statements for database operations, instead of using visual operation tools, because one day you will suddenly find that SQL statements are forgotten, which is a very sad thing.
2. When an SQL statement is wrong, the
I am using rhel5.1, which is a higher version of RedHat Enterprise Edition (higher I have seen 5.3 ). In rhel5.x and later versions, Red Hat has enhanced copyright control, mainly because the GUI manager of the software package is not used at will,
1./etc/My. CNF Default Configuration
The configuration file is as follows:
[Mysqld]
Datadir =/var/lib/MySQL
Socket =/var/lib/MySQL. Sock
# DefaultTo using old password format for compatibility with MySQL 3.x
# Clients(Those using the mysqlclient10
The following is an example of MySQL installation. It is installed using an executable file!
1. Open the mysqlinstallation file mysql-5.0.27-win32.zip, decompress the file, and run “setup.exe. The following interface is displayed:
Start the MySQL
1. log on to MySQL-uroot-P.
2. MySQL cannot be accessed from the Internet in Linux
You have granted permissions in MySQL. It is still inaccessible on the Internet.
Problem:
CAT/etc/MySQL/My. conf
Find the following line
Bind-address =
The uniq command can only remove repeated items.
Test text
[shuohai.lhl@v035114 bin]$ cat test 711[10.235.170.22:8123] 0 10.232.20.178 1648042 1648042 0 2013-07-29 20:01:35 711[10.235.170.22:8123] 11
Method 1:
Mysql5.0 has been installed in the Windows Installation Package of mysql5.0. After that, the system is reinstalled, but you do not want to reinstall mysql5.0.So I want to manually restore the previously installed mysql. My previous
It is important to back up your database when database tables are lost or damaged. In the event of a system crash, you must be able to restore as much data as possible from your table to the State at the time of the crash. Sometimes it is the MySQL
Although this script is relatively simple, I think it will help us a lot!To put it simply:Db_user = "user" is the user name.Db_pass = "password" is the password
Mkdir/home/mysqlbak/$ date specifies and creates the directory to be backed upBin_dir = "
If reproduced, please respect personal labor, be sure to indicate the original source: (http://blog.csdn.net/iihero/archive/2010/05/13/5585039.aspx)
This article is original to iihero @ csdn.
I mentioned my in the previous article. INI/CNF:
PS: This article is reproduced from http://blog.csdn.net/lyjinger/article/details/1648845
Lyjinger software: MySQL Server installation and configuration
Note: I have some experiences in installing and configuring the MySQL server. MySQL 5.0.41,
1. Win + R-> Enter cmd to enter the command line,
2. Go to the bin directory under the MySQL installation directory) G: \ Program Files \ mysql server 5.6 \ bin
3. Enter
Mysql-u root-pyoupassword
Press enter and you will be prompted to enter the
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