1045 error
Posted by: darkaria (---.dhcp.insightbb.com)
Date: September 28, 2009 09:27PM

I am new to this

when I click on phpmyadmin I get

Error
MySQL said:

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

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

how do I fix this?

Options: ReplyQuote
Re: 1045 error
Posted by: darkaria (---.dhcp.insightbb.com)
Date: September 28, 2009 09:45PM

I fix some of it, I now get a login screen but when I type in my user name 'root' then my password I get

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

Log in
Username: root
Password:

Options: ReplyQuote
Re: 1045 error
Posted by: yfastud (Moderator)
Date: September 28, 2009 11:31PM


Options: ReplyQuote
Re: 1045 error
Posted by: darkaria (---.dhcp.insightbb.com)
Date: September 29, 2009 12:51AM

nowI am getting this error

phpMyAdmin - Error
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

Options: ReplyQuote
Re: 1045 error
Posted by: darkaria (---.dhcp.insightbb.com)
Date: September 29, 2009 03:47AM

I need some help..........how can I fix this problem? I am almost to the point of giving up.....I have spent 7 hours today trying to get this working..........what am I doing wrong?

Options: ReplyQuote
Re: 1045 error
Posted by: yfastud (Moderator)
Date: September 29, 2009 04:04AM

did you try the answer for you posted on my blog???

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: 1045 error
Posted by: darkaria (---.dhcp.insightbb.com)
Date: September 29, 2009 04:12AM

yes

I now get the

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

here is my config.inc.php

/*
$cfg['blowfish_secret'] = ‘wizard’;
$i++;
$cfg['Servers'][$i]['verbose'] = ‘localhost’;
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['port'] = ”;
$cfg['Servers'][$i]['socket'] = ”;
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;
$cfg['Servers'][$i]['extension'] = ‘mysqli’;
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;
$cfg['Servers'][$i]['user'] = ‘root’;
$cfg['Servers'][$i]['password'] = ‘wizard123′;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

*/

what is wrong with this?.......

I can't seem to log into myphpadmin now, and all I did was fallow some directions to add a password. I really want to learn this stuff, but darn I can not even get it configures correctly?

Options: ReplyQuote
Re: 1045 error
Posted by: darkaria (---.dhcp.insightbb.com)
Date: September 29, 2009 04:15AM

I am posting here and on your blog...........darn it I want to get this right.......I am ready to learn this stuff, and get to building data base driven websites

Options: ReplyQuote
Re: 1045 error
Posted by: darkaria (---.dhcp.insightbb.com)
Date: September 29, 2009 06:28AM

ok I wasdoing somw searching I found this

--------------------------------------------------------------------------------

is there a user set up in mysql root@localhost ?

can you access mysql from the command line?

if so do

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

where 'some_pass' is the password you want to use

--------------------------------------------------------------------------------

i opened up dos prompt and typed

mysql -u root -p (hit enter)

(got)mysql>

then I did as he said, and when I tried to log into phpmyadmin it worked........could you explain why it worked so I will somewhat understand what I did?

is there anything else I need to do, before I start doing tutoial and trying to learn this stuff?

Options: ReplyQuote


Sorry, only registered users may post in this forum.