WampServer

Hello ,im very tired of searching to find solution for this problem
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I have installed wamp on Windows Server 2008 R2 Enterprise

but when go on localhost/phpmtadmin ,can't connect to Mysql Server

im using VPS like user ,not with all access like Administrator ,can this problem be?

also i have tried setting password on config.inc.php , but nothing changes
also can't connect to mysql via mysql console (tried using password ,and without password)

On my computer works perfect ,but on VPS don't ?

see image: [i.imgur.com]

Anyone know the problem?



Edited 2 time(s). Last edit at 06/19/2015 07:08PM by erandi1993.

What password are you using.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

i have tried passwords: root, erandi1993 etc... , also without password ,but still dont work
VPS is 64 bit system ,and i have installed wamp for 64 bit

if you can fix ,i will send you TeamViewer and you can look up for solution ?



Edited 1 time(s). Last edit at 06/19/2015 09:54PM by erandi1993.

Out of the box the MySQL

user account = 'root'
password.= blank ( no password)

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Sorry but i dont understand what you mean ,
here is my code on config.inc.php:

$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'localhost';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

It sounds like you may have another MySQL running.

How to check:

Windows Key + R
Keying services.msc
Press OK button

Look for a service called 'MYSQL'

The WAMPServer version of MySQL is called wampmysql or wampmysql64(if you installed 64bit WAMPServer)


If you find any other mysql service running it is probably that that is causing the problem.

So you will have to decide if you accidentally installed it in which case Uninstall it. OR if you were actually using it whether you still actually need it.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Yes sure is runin another mysql with 3306 port ,but i dont know password of him,
so i have deleted ,now phpmyadmin is working perfekt ,Thank you very much brother

but now i have another problem ,when i set password on mysql ,phpmyadmin again dont work

i tried using command: UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE User='root';
but he said: update is not recognized as an internal or external command operable program or batch file



Edited 2 time(s). Last edit at 06/21/2015 01:21PM by erandi1993.

You obviously dont yet understand MySQL Server.

It is a database manager that can manager multiple actual databases ( its not like access ) so you only need one MySQL server on your system. You can run more than one but you need to know what you are doing, and it will use twice the memory that you probably dont have that much of.

Now you say you have mysql Workbench installed. That will be why you have two instances of MySQL Server. There are 2 versions of MySQL Workbench, one that is just the workbanch and one that is the workbench and an instance of MySQL Server as well.

So this is what I suggest you do:

1. Backup(export) any databases that you have created in MySQL Workbench, make sure that these backup files are stored somewhere safe.

2. Uninstall MySQL Workbench and the MYSQL Server that came with it.

3. Install MySQL workbench ( the version without the MySQL Server instance )

4. Start WAMPServer, make sure the icon goes Green.
... The username should now be 'root' and the password shoudl now be blank i.e. no password.
... Test this using phpMyAdmin

5. Restore you database backups, using phpmyadmin or mysql workbench.


You should now be running the mysql that came with WAMPServer.

phpMyAdmin should work
MySQL Workbench should also be able to see and connect to the WAMPServer version of MySQL Database server.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Yes i fixed is working phpmyadmin thank you very much, but now i have another problem ,when i set password on mysql ,phpmyadmin again dont work


and when i use: update mysql.user set password = password('mypasswordhere') where user = 'root';

it gives me this error: ERROR 1064 <42000>: You have an error in your SQL syntax etc...



Edited 2 time(s). Last edit at 06/21/2015 01:32PM by erandi1993.

Well if you think about it when you change the password on the 'root' account it will no longer match the one stored in the \wamp\apps\phpmyadmin4.1.14\config.inc.php

My prefered solution is to make a couple of changes to \wamp\apps\phpmyadmin4.1.14\config.inc.php so that phpmyadmin throws a login screen when you launch it.

This way you can create other user accounts and use the login screen to test them.

So edit \wamp\apps\phpmyadmin4.1.14\config.inc.php

Find this section

$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

And change them to

$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';

$cfg['Servers'][$i]['auth_type'] = 'cookie';
//$cfg['Servers'][$i]['auth_type'] = 'config';
//$cfg['Servers'][$i]['user'] = 'root';
//$cfg['Servers'][$i]['password'] = '';

/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['AllowNoPassword'] = false;

Save the file and then restart Apache so it picks up these changes.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Thank you i fixed ,

Another thing ,when i try to connect from my VPS ip to my website ,it connect
how can i disable access from IP of VPS ,but just from domain name



Edited 1 time(s). Last edit at 06/21/2015 02:49PM by erandi1993.

Thats how stuff works.

Try connecting to '89.31.144.71` you will get to the WAMPServer site.

Everything actually uses the ip address, its only us humans that use a name as its easier to remember. Thats what we use DNS Server for, to convert a name we can remember to a ip address which is what ALL software actually uses.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

but i know a lot of websites that are disabled to access from IP address ,but just from domain name ,
is there anyway ?

Please show me an example

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

www.mistreci.com ~> 62.210.190.57

That blocking is done by CloudFlare

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

okej leave it ,but how can i secure my website from DOSS attack ,i'm Hacker and i know doing bad things like dossing or hacking

i tried to doss my website and ti goes down for a while ,do u know anyway to protect him ? wamp server can't protect.

i tried to doss also wampserver.com ,and works ? ,please make something to protect



Edited 1 time(s). Last edit at 06/21/2015 05:30PM by erandi1993.

Google "apache ddos protection"

If you are such an expert hacker, maybe you can use this knowledge to develop the definitive protection tool or are you just a muppet with a "Hacker for morons" tool copied from the internet, which probably comes complete with all the required backdoors installed to make you just another bot in a real experts herd.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

ok thank you ,i have just one thing to ask you, How can i host multiple websites on wamp ?

You mean just one more thing!

You could always just read the documentaiotn I provided as a STICKY document on the forum index.

WAMPServer 2.5 The Homepage, Your Projects Menu and the need for Virtual Hosts

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-