its me wrote:I need badly to secure and arrange those databases under user issue
its me wrote:in xampp comes in default databases such as col, test, information_schema, webdav... and others...
1- how i can know each one is for what? where to find this list?
2- if i want to rename them from "operation" tab in each one's interface, what will happen?
3- there is databases called "phpmyadmin" is it rename-able???
its me wrote:4- what about the users in "privileges" tab? i see more than one "root" and without password! how we can create 2 users with the same spelling?
its me wrote:5- why without password (written "NO") in red, under password column....? isn't security issue?
its me wrote:5- what is the different if i change the host to "any" and "localhost" for each user?
its me wrote:6- i need to keep only one root user, and delete the other root users, what will happen and which one to keep?
its me wrote:truly appreciated your time dear Altrea,
its me wrote:so, as far i understand, i should remain phpmyadmin, mysql, performance_schema, information_schema as without renaming, just leave them like this...
its me wrote:1- all others are not a problem if i go ahead and rename them, or delete them right?
its me wrote:2- about users, i want to keep one "root" user which i added a password for it... all other which they are "root" but without password i want to remove, is it ok?
its me wrote:3- i am having really bad time in how to setup the .htaccess thing...
its me wrote:ok let see, about the backup, how i can backup all of them so i can restore them if something happen after the renaming?! i don't see reasonable backup solution
its me wrote:- about the root issue, i wonder also, i am speaking about the default what comes with xampp by default, there is more than one root user, i already configured one root and put a psssword for it, other "root"
its me wrote:- i understand it is a new topic, i though u would remember this one viewtopic.php?f=16&t=48590 but whatever, just let me try more and will let you know in that topic, or i might crate a new topic only for this....
Perhaps suggesting a book or 'real tutorial' may be more helpful.JonB wrote:What you really need is a book or 'real tutorial' (not a three or four screen web special) about MySQL.
its me wrote:ok dear, i noticed that, so i will leave it without password, i hope it will not be security risk later....
its me wrote:to be honest, i didn't notice this user in my older servers setup, mybe it was there....
Mike, adding plain text passwords in configuration files is a big security risk and totally unnecessary and should be avoided.Altrea wrote:...but you have to tell the password your phpmyadmin config page too.
Users browsing this forum: Nobbie and 59 guests