You are not logged in.
I have searched everywhere for this and could not turn up any useful information.
First off, I have been able to log in to phpmyadmin since I installed my Arch Linux server. I did an update the other day (was a month behind on updating) and now cannot log in through phpmyadmin.
When I try I get #1043 Cannot log in to the MySQL server.
Things I have tried.
1) Updated my config.inc.php in /etc/webapps/phpmyadmin/
2) Checked over my my.cnf in /etc/mysql/
3) Search google for numerous days!
4) Tried to Enabling Configuration Storage. I read in a few places that this could solve my issue.
I could not complete this as when I run
mysql -u root -p < /usr/share/webapps/phpMyAdmin/scripts/create_tables.sql
I get an error stating
ERROR 1064 (42000) at line 30: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS 'pma_bookmark' ('id' int(11) NOT NULL auto_increment' at line 10
I am really at a loss of words here and am about to pull my hair out. Help would be much appreciated.
Last edited by shadowmoses (2012-02-24 03:26:38)
Offline
fail
Last edited by yaffare (2012-02-18 01:00:47)
systemd is like pacman. enjoys eating up stuff.
Offline
Thanks for you constructive criticism. I must say that is quite a douche bag statement.
Offline
you have to add this to your config.inc.php
$cfg['Servers'][$i]['AllowRoot'] = TRUE;
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = TRUE;
systemd is like pacman. enjoys eating up stuff.
Offline
sorry the "fail" was ment for me, I just missclicked
systemd is like pacman. enjoys eating up stuff.
Offline
you have to add this to your config.inc.php
$cfg['Servers'][$i]['AllowRoot'] = TRUE; $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; $cfg['Servers'][$i]['AllowNoPasswordRoot'] = TRUE;
I have AllowRoot enabled and the others are false as this is a public server. This still does not solve the issue though. Like I said it was working until the upgrade .
Offline
strange cause you obviously can login from cli.
but you login in from localhost, meaning lamp all on 1 server?
maybe try create another user
mysql -u root -p
CREATE USER 'test123'@'localhost' IDENTIFIED BY 'test123';
GRANT ALL PRIVILEGES ON *.* TO 'test123'@'localhost' WITH GRANT OPTION;
then login with
username test123
password test123
if not I would remove phpmyadmin completely then check manually if all files are gone and reinstall.
I also tested mysql -u root -p < /usr/share/webapps/phpMyAdmin/scripts/create_tables.sql, it works for me,
wonder why you get an sql error here.
systemd is like pacman. enjoys eating up stuff.
Offline
its saying that on that .sql file on line 30, there is an syntax error and its not going to import due to that error. so you should check your .sql file and see what your missing or what shouldnt be there and if you need help, post lines 28 - 32 on here just so we can help you better
A Complex man who likes the simple things in life.
Owner of YourIRC networks at http://yourirc.net/ and ssfdre38.com
Offline
As said, your login data is ok and you are connected.
The problem is - your .SQL file is probably corrupted.
Offline
How did you update phpmyadmin? Manually (like I hope you installed it in the first place) or with pacman? It's probably a permission thing.
Online
I installed it with pacman. I think I have discovered the issue though.
I re-installed the config.inc.php and I could log in fine. So when I tried to add $cfg['Servers'][$i]['ssl'] = true; I could no longer log in.
Really weird, I have been running that for years. Maybe they removed that feature, who knows.
Oh and that sql error is the actual file distributed with pacman for phpmyadmin. It is in the /usr/share/webapps/phpMyAdmin/scripts folder.
Offline
I would also like to everyone for attempting to help.
Offline
They change the force SSL option to:
$cfg['ForceSSL'] = true;
Again thanks for the help all.
Offline