Solution to MySQL Administrator failure

Source: Internet
Author: User
Tags mysql tutorial

The "cocould not find settings" error pops up in the mysql tutorial administrator.

Solution: Set hkey_local_machinesystemcurrentcontrolsetservicesmysqlimagepath in the registry.
The value is changed from c: mysqlbinmysqld.exe mysql to "c: mysqlbinmysqld.exe" -- defaults-file = "c: windowsmy. ini" mysql

Problem: php tutorial 5 fatal error: call to undefined function mysql_connect () in
Solution: I updated php too early. ini is copied from the php Directory to the windows directory. As a result, I changed phpphp. ini, but not windowsphp. ini file, you only need. ini is copied from the php folder to the windows directory.

 

Question 2


Log on to the mysql administrator with the following error: either the server service or the configuration file cocould not be found. startup variable and service section are there for disabled.

After you log on to mysql as a root user, the management function is disabled. The following message is displayed: this section is only avaliable when connected to localhost solution: when you click mysql administrator, do not click log on, press ctrl to display the rightmost cancel key as skip. Click to enter the Security Configuration Mode. Here you can start or create a service. Here, you can configure the parameters of my. ini in gui. You can select the parameters corresponding to my. ini. Note: If the red parameters indicate errors, you should adjust them. If you cannot restart mysql administrator after modification, You need to restart the system.


Mysql administrator error, 1045


The root user needs to enter a password during installation. The password 123456 here is different from the one set during installation.

Telnet fig 3306
If the connection fails, check whether the mysql service is enabled or the firewall does not allow access to port 3306.

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.