MySQL Forums
Forum List  »  Newbie

Re: ERROR 1045 (28000) Access denied for user 'root'@'localhost'. Symfony. Bitnami WAMP
Posted by: gintare statkute
Date: March 08, 2015 01:37AM

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?

Options: ReplyQuote




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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.