• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

No access to the accounts on phpmyadmin

AlDoX94

New Member
Joined
Jan 6, 2011
Messages
4
Reaction score
1
Server Version: theforgottenserver-v0.2.15-console

Problems: _Can't start the server, it says theres some problem with the mysql and tells me to change it to sqlite
_Can't manage the accounts on phpmyadmin
consulta SQL:

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

MySQL said:

#1142 - SELECT command denied to user ''@'localhost' for table 'pma_table_uiprefs'

_Can't use
DROP USER 'pma'@'localhost';
#1396 - Operation DROP USER failed for 'pma'@'localhost'

I'll appreciate very much your help :)
 
I cant see the images. Have you properly configured mysql and set up the OT accordingly? plus, did you import the appropriate schema?
 
I cant see the images. Have you properly configured mysql and set up the OT accordingly? plus, did you import the appropriate schema?

i'm using mysql, why i should import an schema? i just imported the forgottenserver.sql
 

Attachments

Back
Top