default databases pre-installed in phpmyadmin? [SOLVED]
Posted: 15. October 2011 18:15
hello guys,
today i have short questions about renaming the default databases came preinstalled in xampp 1.7.7 (i'm using windows server 2008 R2 and working fine)
I need badly to secure and arrange those databases under user issue
something like: username_databasename
e.g. databases:
mike_mailform
mike_requestform and user will be e.g. "mike" for both databases
e.g. databases:
sirg_dbmain
sirg_dbsecondory and user for both will be e.g. "sirg"
then as you know, they will be sorted in phpmyadmin like mike - then the databases underneath...
I hope you understood the point/scenario i want to reach
so, now?
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???
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?
5- why without password (written "NO") in red, under password column....? isn't security issue?
5- what is the different if i change the host to "any" and "localhost" for each user?
6- i need to keep only one root user, and delete the other root users, what will happen and which one to keep?
Thanks in advanced for providing answers guys, I'm loving xampp each day
Mike
today i have short questions about renaming the default databases came preinstalled in xampp 1.7.7 (i'm using windows server 2008 R2 and working fine)
I need badly to secure and arrange those databases under user issue
something like: username_databasename
e.g. databases:
mike_mailform
mike_requestform and user will be e.g. "mike" for both databases
e.g. databases:
sirg_dbmain
sirg_dbsecondory and user for both will be e.g. "sirg"
then as you know, they will be sorted in phpmyadmin like mike - then the databases underneath...
I hope you understood the point/scenario i want to reach
so, now?
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???
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?
5- why without password (written "NO") in red, under password column....? isn't security issue?
5- what is the different if i change the host to "any" and "localhost" for each user?
6- i need to keep only one root user, and delete the other root users, what will happen and which one to keep?
Thanks in advanced for providing answers guys, I'm loving xampp each day
Mike