Mysql FAQ 1th/2 page _mysql

Source: Internet
Author: User
1
After installing MySQL, change the root password and use
NET Startmysql
I ran into this problem when I started. After you use the following command
C:\mysql\bin\mysqladmin-u root-p shutdown
Again net start MySQL does not have this error hint!


*************
2
MySQL's 1067 error


Q: My MySQL ran into 1067 errors

The error message is:
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.

A: The solution on my machine is:
Modify%windir%\my.ini, increase
[Mysqld]
#设置basedir指向mysql的安装路径
Basedir=d:\program\tools\mysql
Datadir=d:\program\tools\mysql\data


*************
3
It's ready!!!
It's like this ...
The mysql_install_db script only needs to run once during the initial installation, and then it doesn't have to run anymore, and I don't know if that's the case. I'm going to copy Mysql.server to/etc/rc.d/init.d/and run Chkconfig Mysql.server, so that the MySQL server automatically start every time, as long as you set the path, on the command line to enter MySQL on everything to fix!
It seems that the groping process is really painful ah, this has tortured me for several days ...

*************
4

Q: My MySQL ran into 1067 errors

The error message is:

A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.

For:
Solution:

1. Check your MySQL directory for system user privileges.
2. Delete your%windows%/my.ini file.
3. Check that your C:/MY.CNF file is configured correctly.


*************
5

"☆☆☆mysql Outline ☆☆☆"
MySQL's default installation directory is C:mysql, after the installation of the end without any hint that the installation is over, please click the Finish button and so on, directly out of the. If you need to install to a different directory, it is recommended that you first install to C:mysql, and then move the entire directory to where you want, for example, after moving to D:mysql, you need to edit d:mysqlmy-example.cnf (*.cnf files in Windows 2000 will be registered as a SpeedDial file, unable to operate in the explorer, to start Notepad editing with the command line, such as running NOTEPADD:MYSQLMY-EXAMPLE.CNF, but this file is a text file format under the UNIX system. In Notepad, you can't wrap the line correctly, you can open the edit with write,
or save it once with write open, then use Notepad to edit it. Locate the Basedir row, remove the previous "#" comment, change the following path to the moved directory (the directory delimiter should be slash instead of backslash), and save as: c:my.cnf
Current 1/2 page 12 Next read the full text
Related Article

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.