Re: ERROR 1045 (28000) Access denied for user 'root'@'localhost'. Symfony. Bitnami WAMP
1) I am not able to login to MYSQL through console
using command: mysql -u root -p
I am getting error: ERROR 1045 (28000) Access denied for user 'root'@'localhost' (using password: NO)
2) I am not able to login to PhpMyAdmin, using user "root" and empty field for password. The user is not recognised.
in folder C:\Bitnami\wampstack-5.4.36-0\apps\phpmyadmin\htdocs\config.inc.php
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['nopassword'] = true;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
I use command: mysql --help --verbose
It output the following directories and filenames:
Default options are read from the following files in the given order:
C:\Windows\my.ini
C:\Windows\my.cnf
C:\my.ini
C:\my.cnf
c:\bitnami\wampstack-5.4.36-0\mysql\my.ini
c:\bitnami\wampstack-5.4.36-0\mysql\my.cnf
I could not find (they does not exist):
C:\my.ini
C:\my.cnf
C:\Windows\my.ini
C:\Windows\my.cnf
c:\bitnami\wampstack-5.4.36-0\mysql\my.cnf
I found only
c:\bitnami\wampstack-5.4.36-0\mysql\my.ini
which does not contain password option. The contents without most of comments:
[mysqldump]
max_allowed_packet=16M
[isamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M
[myisamchk]
key_buffer_size=20M
sort_buffer_size=20M
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
[mysqladmin]
user=root
port=3306
# set basedir to your installation path
basedir=C:/Bitnami/WAMPST~1.36-/mysql
# set datadir to the location of your data directory
datadir=C:/Bitnami/WAMPST~1.36-/mysql\data
port=3306
#skip-locking
key_buffer_size=16M
max_allowed_packet=16M
table_cache=64
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
bind-address=127.0.0.1
How to change mysql configuration?