ysptheband22
New Member
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Well, the title says it all: even though I have given a MySQL user full privileges to my database, it won't show up in phpMyAdmin. Also, in scripts, the command mysql_select_db won't work, and when I try "SHOW TABLES FROM `*database name*`" in the SQL window at phpMyAdmin, it gives an acces denied message, even though I'm fully privileged for that database.
Server: https://boru.x10hosting.com:2083/3rdparty/phpMyAdmin/
User: ysptemp_root, database: ysptemp_db. It also happens at any other user or database I create.
Additional information (as in phpMyAdmin):
cpsrvd 11.28.87
MySQL-client version: 5.0.92
PHP extension: mysql
---------- Post added at 05:17 PM ---------- Previous post was at 11:31 AM ----------
Oops, sorry folks, I made some mistakes in my past post, and also discovered some other oddities.
Through scripts in public_html, everything works flawless; I can acces all databases.
However, phpMyAdmin screws everything up. It informs me that there are 'no databases', and the SQL query "SHOW TABLES IN `table_name`" redirects me to the main pMA screen. I don't really need pMA, except for importing the database on my local testing server. So, my question comes down to two things:
-Can someone please fix pMA on the boru server?
-How to import SQL files without pMA?
Server: https://boru.x10hosting.com:2083/3rdparty/phpMyAdmin/
User: ysptemp_root, database: ysptemp_db. It also happens at any other user or database I create.
Additional information (as in phpMyAdmin):
cpsrvd 11.28.87
MySQL-client version: 5.0.92
PHP extension: mysql
---------- Post added at 05:17 PM ---------- Previous post was at 11:31 AM ----------
Oops, sorry folks, I made some mistakes in my past post, and also discovered some other oddities.
Through scripts in public_html, everything works flawless; I can acces all databases.
However, phpMyAdmin screws everything up. It informs me that there are 'no databases', and the SQL query "SHOW TABLES IN `table_name`" redirects me to the main pMA screen. I don't really need pMA, except for importing the database on my local testing server. So, my question comes down to two things:
-Can someone please fix pMA on the boru server?
-How to import SQL files without pMA?
Last edited: