Phpmyadmin error

[super23]

Hi, so when im trying to log into phpmyadmin it doesnt let me and gives an error could someone help me solve it please?

 

[LazyBear]

Where are you running phpMyAdmin? Windows? Ubuntu? Also, what are you using? XAMPP, Uniform server...?

 

[super23]

Where are you running phpMyAdmin? Windows? Ubuntu? Also, what are you using? XAMPP, Uniform server...?

Im using VMware so linux debian 8

 

[LazyBear]

Can you try reconfiguring?

sudo dpkg-reconfigure phpmyadmin

 

[super23]

Can you try reconfiguring?

sudo dpkg-reconfigure phpmyadmin

i tried that but still didnt work i maybe done something wrong as im not really experienced in it could u tell me what settings i need to choose or something to help me out ?

 

[LazyBear]

If that doesn't help, try accessing manually:
Edit the following file

/etc/phpmyadmin/config.inc.php

Find and uncomment (remove at beginning "//")

$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

Find and comment (add at beginning "//")

$cfg['Servers'][$i]['controluser'] = $dbuser;
$cfg['Servers'][$i]['controlpass'] = $dbpass;

This will grant you access without requiring user/password.

 

[super23]

If that doesn't help, try accessing manually:
Edit the following file

/etc/phpmyadmin/config.inc.php

Find and uncomment (remove at beginning "//")

$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

Find and comment (add at beginning "//")

$cfg['Servers'][$i]['controluser'] = $dbuser;
$cfg['Servers'][$i]['controlpass'] = $dbpass;

This will grant you access without requiring user/password.

oh, that helped i think the error at the bottom has gone now and its just giving this error:

#2005 Cannot log into the MySql server

 

[LazyBear]

Look up for something

$cfg['Servers'][$i]['host']

Do you have 127.0.0.1 or localhost? Try exchanging.

 

[super23]

Look up for something

$cfg['Servers'][$i]['host']

Do you have 127.0.0.1 or localhost? Try exchanging.

Thanks a lot! Im in

 

[LazyBear]

As now phpMyAdmin is accessible for anyone, make sure to find out any troubles and protect it again. Meanwhile, rename "phpmyadmin" file access inside your /www/ so not everyone can access easily.

 

[super23]

As now phpMyAdmin is accessible for anyone, make sure to find out any troubles and protect it again. Meanwhile, rename "phpmyadmin" file access inside your /www/ so not everyone can access easily.

i can now log into my phpmyadmin but now its giving me this error:

https://imgur.com/46sIKxw

would u know about this?

 

[LazyBear]

Installation — phpMyAdmin 5.1.4 documentation

"To find out click here." does it give you more details? If everything is "OK" in green, or if you see "Create missing phpMyAdmin configuration storage tablet", click on "Create". Find out which is NOT OK, should be something related to "$cfg['Servers'][$i]...". If there's an option to configure/enable, do it.

Alternatively, find again inside $cfg config.inc.php and look for "table_uiprefs" and change it to "pma__table_uiprefs". Perhaps it is a tricky solution, but before doing this, try to fix it through phpMyAdmin itself.

 

[super23]

when i click on "here" on my phpmyadmin it gives me a page with a bunch of these

https://imgur.com/51Flv4K

Im not sure what this means.

 

[super23]

i got phpmyadmin working but then when i tried setting up my website i got this error

https://imgur.com/jEulfm2

and when the website files are in the /var/www/html folder it says 403 - Forbidden, but 1 website works but its not the right version so i need a this to work. If u could help that would be nice. Thanks