Cannot Login to phpmyadmin
-
Hey everyone,
I followed the tutorials on setting up phpmyadmin and now i can see the phpmyadmin login screen but cannot login as root. I just keep getting this message.#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I know what my root password is and I am typing it in correctly. Any ideas.
Posted 2 years ago # -
Just wondering, are you typing in your root password for the MySQL system or Linux?
Posted 2 years ago # -
Typing the root password that I set up when installing MYSQL. just tried logging into mysql via terminal with root password and couldn't do that either. Checked the daemon and found errors
mysqld: 100503 23:30:35 InnoDB: Operating system error number 13 in a file operation.
mysqld: InnoDB: The error means mysqld does not have the access rights to
mysqld: InnoDB: the directory.
mysqld: InnoDB: File name ./ibdata1
mysqld: InnoDB: File operation call: 'open'.
mysqld: InnoDB: Cannot continue operation.
mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid endedPosted 2 years ago # -
Just fixed it. I had two versions of mysql installed .. mysql-server and mysql-server 5.1 or something like that. I think on installing it I also answered one of the questions incorrectly about allowed remote login for root. Yay!
Posted 2 years ago # -
I'm having the same issue. Except i'm trying to login with my user password and root and it's not working.
@geoffrey, how did you find out you had 2 mysqls installed?? Maybe I"m having the same issue.
Posted 2 years ago # -
Wait NVM. You have to use the root password set during the mysql_secure command
Posted 2 years ago # -
Yeah, thats could be what was causing my issue too. To check what packages you have installed in ubuntu I used something like "dpkg --get-selections"
Posted 2 years ago # -
hey guys .. tell me, sounds like there's something that isn't clear in the phpmyadmin setup guide???
pls lemme know a bit more detail if that's the case
pleased you're sorted tho.
Posted 2 years ago #
Reply
You must log in to post.
Want HTML?
a blockquote code em strong ul ol liPlace code between backticks `codeHere`
You've got it.
