+- Linux-Noob Forums (https://www.linux-noob.com/forums)
+-- Forum: Linux Server Administration (https://www.linux-noob.com/forums/forum-8.html)
+--- Forum: LAMP (https://www.linux-noob.com/forums/forum-83.html)
+--- Thread: mySQL (/thread-3361.html)
mySQL - Oroshi - 2004-05-25
I am just wondering any of you use multi-user login for phpMyAdmin. I use login via HTTP which is pop up a login dailog a lot likely .htaccess, but just for mySQL's username ans password.
so i got root works and venom. What i want is, Root to keep Full settings such as "Privileges" access. other user are not supposed to see "Privileges". also i am trying to make user that allow to create databas after thier username such as venom_
so i want to add for forum, so i use venom_forum.
I cannot get it to work it kept apeared "Access Denied" the wild card use backsash like venom\_ it will turn out real undersorce. so i want to add after the undersorce. it won't i've tried to do this venom\_\ it won't write in SQL 's Privileges
Any idea?
mySQL - TormentoR - 2004-05-27
don't use '_' in usernames, tablenames, etc.
mySQL - Oroshi - 2004-05-27
If i don't use the '_' then how can i create a database?
what i am trying to do is; they can choose whatever they want after the undersore. E.G.
For forums use:
vemon_forum
news:
vemon_news
stats:
vemon_stats
do you know what i mean?