search
Categories
Sponsors
VirtualMetric Hyper-V Monitoring, Hyper-V Reporting
Archive
Blogroll

Badges
MCSE
Community

Cozumpark Bilisim Portali
Posted in Hosting & IIS7, Windows Server | No Comment | 5,202 views | 25/10/2011 12:53

You may get this error when you try to access MySQL server on Windows.

Host ‘localhost’ is not allowed to connect to this MySQL server.
Host ‘127.0.0.1’ is not allowed to connect to this MySQL server.

Solution:

1. Stop MySQL service (from services.msc)

2. Create a text file in C:\ called “init.txt”. Paste the following code and save it.

GRANT ALL PRIVILEGES ON mysql.* TO root@localhost IDENTIFIED BY 'YourPassword!' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON mysql.* TO root@127.0.0.1 IDENTIFIED BY 'YourPassword!' WITH GRANT OPTION;

3. Open command prompt (cmd)

4. Go to MySQL bin directory on cmd.

Example: C:\Program Files\MySQL\MySQL Server 5.1\bin



Posted in Linux Server, Windows Server | No Comment | 3,642 views | 18/02/2009 01:49

Zip paketinden MySQL kurulumu yaptıysanız, boş olan root şifresini cmd ya da ssh üzerinden aşağıdaki komutla değiştirebilirsiniz.

1
mysqladmin -u root password YENISIFRE

Mysqladmin komutunun direk olarak çalışabilmesi için Mysql path’ini “System Paths” içine eklemeyi unutmayın.