• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows ? Need assistance with phpmyadmin errors!

The Tank

New Member
Joined
Jan 17, 2009
Messages
9
Reaction score
0
Having some more problems with phpmyadmin,, Again... Anyways when i log in, select my database everything works fine. Now if i try to open ANY folder/file ie. accounts/accountbans/guilds, whichever file it may be I get this error! I've searched google- no luck.. also been searching around on the forums found a few things tried those but nothing changed so now im asking.. Also got a few more little problems I need help with but i'll just ask one at a time. Thank you for any input!

Error

SQL query: DocumentationEdit Edit

SELECT `prefs`
FROM `phpmyadmin`.`pma_table_uiprefs`
WHERE `username` = 'root'
AND `db_name` = 'fantasyland'
AND `table_name` = 'accounts'

MySQL said: Documentation
#1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'
 
Look on the priviliges?

- - - Updated - - -

cuz it says denied to user

User Host Type Privileges Grant Action
root linux global ALL PRIVILEGES Yes Edit Privileges Edit Privileges
root localhost global ALL PRIVILEGES Yes Edit Privileges Edit Privileges

All privs are checked under edit, also it says "host linux" i dont use linux not sure if that needs to be changed?

- - - Updated - - -

I have some other minor issues that need to be solved.. I know they all have to be simple fixes that im just looking past.. So if someone can PM me or PM me and we can get on my vent if anyone is willing to walk me through these issues! Please and Thank You!
 
It looks like your trying to do a select statement without being connected as a user.
Otherwise I think the error message would look like this:

SELECT command denied to user 'root'''@'localhost' for table 'pma_table_uiprefs'
 
Are you using Xampp or Uniserver?

Xampp

- - - Updated - - -

It looks like your trying to do a select statement without being connected as a user.
Otherwise I think the error message would look like this:

SELECT command denied to user 'root'''@'localhost' for table 'pma_table_uiprefs'

How do i connect to a user? or know if i am connected correctly?

If you talking about connected as in, account on the website, i am..

Noobie with this part :/ so thank you for your help guys
 
Back
Top