Error While Logging into MYSQL
Posted by: Nihar (45.115.191.---)
Date: January 18, 2018 06:52PM

Hi All, I am new to wampp and I have successfully installed wamp 3.1.0 and it has phpMYAdmin 4.7.4

problem is I am unable to log on into MYSQL .


currently : (FOR MYSQL) the config file reads :

$cfg['Servers'][$i]['verbose'] = 'MySQL';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['port'] = $wampConf['mysqlPortUsed'];
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

and for maria db it reads:

$cfg['Servers'][$i]['verbose'] = 'MariaDB';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['port'] = $wampConf['mariaPortUsed'];
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';

pretty much the same stuff when host ,username and password is concerned.

in case of maria db ,in the console when am using

username "localhost"
passowrd ""

i can go through

but in case of MYSQL

its throwing me "#1045 - Access denied for user 'localhost'@'localhost' (using password: NO)".

I tried setting all set of username and password in config file to no luck.

Cannot get it through ,

What wrong I am doing ?

Any help highly appreciated

Regards
Nihar

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: RiggsFolly (Moderator)
Date: January 18, 2018 07:40PM

Hi

When phpMyAdmin ask for a UserName and Password the default is

Username = root
Password = nothing, leave this blank

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.3 32bit & 64bit)
<Apache 2.4.29/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.39/5.5.28>
<MariaDB 10.2.14> <phpMyAdmin4.8.1> <MySQL Workbench 6.3.10>

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 MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: Otomatic (Moderator)
Date: January 18, 2018 07:40PM

Hi,

Please first fix your first problem completely before asking for anything else.
> 2 of 3 services running
Are all three services running?
Is the Wampmanager icon green?

As long as the three services are not started and as long as the icon is not green it is not worth trying to do something else.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.33 - PHP 7.2.6/7.1.18/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.3.7
Wampserver 3.1.3 64 bit - Apache 2.4.33 - PHP 7.2.6/7.1.18/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.3.7
PhPMyAdmin 4.8.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: Nihar (45.115.191.---)
Date: January 18, 2018 07:54PM

Hey, Thanks for the concern ,

yes,they are green,

Since I am new to the forum ,I don't know how to accept an answer .
In that case I just left a message "Cheers".

Regards
Nihar

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: Nihar (45.115.191.---)
Date: January 18, 2018 07:57PM

@ RiggsFolly,

I have tried that earlier,it dint worked for me .

I again tried and got this

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: Otomatic (Moderator)
Date: January 18, 2018 08:32PM

Hi,

Left-Click Wampmanager tray icon -> MariaDB -> MariaDB Console
As there is no password, when it is asked for, just hit Enter.
You should get a window with something like that:
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.2.12-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
Exit this console by typing Exit.

Do the same with MySQL.
Left-Click Wampmanager tray icon -> MySQL -> MySQL Console
As there is no password, when it is asked for, just hit Enter.
You should get a window with something like that:
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.21 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
Exit this console by typing Exit.

Have you had access to the two consoles, MariaDB and MySQL?

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.33 - PHP 7.2.6/7.1.18/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.3.7
Wampserver 3.1.3 64 bit - Apache 2.4.33 - PHP 7.2.6/7.1.18/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.3.7
PhPMyAdmin 4.8.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: Nihar (45.115.191.---)
Date: January 18, 2018 09:08PM

@ Otomatic ,

Thanks for replying.

in case of Maria Db its great.

exactly on my console as you have mentioned

but ,in case of MYSQL it flashes a screen ,unable to read that on screen.

however running mysql.exe inside the bin folder gives.

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)




I follower some of the links and tried these stuffs:

C:\wamp64\bin\mysql\mysql5.7.19\bin>mysql.exe
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

C:\wamp64\bin\mysql\mysql5.7.19\bin>mysql -uroot -p
Enter password: *****
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

C:\wamp64\bin\mysql\mysql5.7.19\bin>mysql -uODBC -p
Enter password: *****
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: YES)

C:\wamp64\bin\mysql\mysql5.7.19\bin>mysql -uODBC -p
Enter password:
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

C:\wamp64\bin\mysql\mysql5.7.19\bin>

to no success.



Edited 1 time(s). Last edit at 01/18/2018 09:31PM by Nihar.

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: Nihar (45.115.191.---)
Date: January 18, 2018 10:21PM

Hello Future Readers,


The issue is finally fixed .

My observations if you are getting any of the password issues with a fresh installation .i.e means somehow the configuration is not successful.

In the below mentioned post
[forum.wampserver.com]

as Otomatic has replied ,follow the steps ,the job will be easily done.

In my case I was trying to fix the issue ,with the old set up files ,(after performing the steps as mentioned by Otomatic ).
In the end all I did is removed the old set up and did a fresh installation of xampp.

Issue resolved.


***
Few more observation:

If the installation is perfect

() In My SQL the username will be "root" (Automatic ,No need to type it in your browser).
() In case of Maria Db the username will be "localhost" (Automatic No Need to type it in your browser)

and password will be "" (blank).




Special thanks to Otomatic for the help and support.

Regards
Nihar

Options: ReplyQuote
Re: Error While Logging into MYSQL
Posted by: caydee (---.dip0.t-ipconnect.de)
Date: January 25, 2018 01:43PM

In my case I was trying to fix the issue, with the old set up files, (after performing the steps as mentioned by Otomatic ).
In the end all I did is removed the old set up and did a fresh installation of xampp.


What a way to thank Ottomatic! by installing XAMPP and not WAMP..!

Options: ReplyQuote


Sorry, you can't reply to this topic. It has been closed.