Hi its me,
Well, i don't think renaming the default Databases is a great idea. But it is your Environment you can do what you want.
its me wrote:I need badly to secure and arrange those databases under user issue
How do you think the databases are secure then? To secure MySQL Databases, create own users for each applications you want to use. Create own users for each user which should be able to administrate the database.
You can set permissions for each user, so each user can just see the databases you want to see him.
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???
-
mysql,
information_schema and
performance_schema are important MySQL-Databases. I don't think they are renamable without crashing MySQL. If you want to rename them, you can try to Google this, because this is exactly what i have to do to find it out for you
-
test is a mysql Database too, but not needed. Rename or delete it if you don't need it.
-
phpmyadmin is the default database for phpmyadmin settings. This Database is renamable. You can find a variable in the phpmyadmin configuration file config.inc.php for this.
-
cdcol is the database for the CD Collection Example in the XAMPP Administration Page. You can rename or delete that database, if you don't need that example application.
-
webauth: i don't know. If i remember that was a database for an database auth example in prior XAMPP versions. I can't find any reference in the XAMPP 1.7.7 sources.
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?
They are not in every cases the same, they have different HOST settings. HOST defines the computer the user or script tries to login from. localhost and 127.0.0.1 are in most cases the same (localhost is mapped to 127.0.0.1), but if you have changed your Windows HOSTS file or use IPv6 localhost can be something different. Thats why the root user does have both entries.
All users that login with phpmyadmin just need the localhost or 127.0.0.1 HOST, because phpmyadmin is a webapplication which runs from the same computer then the MySQL-Database. The same with all php applications you run in XAMPP.
Other hosts like Computernames or IP-Adresses are just needable if the users have scripts or administrative tools (like MySQL Workbench) on their own computers which they want to use on this database.
its me wrote:5- why without password (written "NO") in red, under password column....? isn't security issue?
Leaving root without password can be a big security issue. If someone has access to your server or your phpmyadmin, your Database is full administratable for him. He can delete, rename, add everything in there.
its me wrote:5- what is the different if i change the host to "any" and "localhost" for each user?
any means "any Host exept localhost", because localhost has a default anonymous user which would match before any host.
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?
Why? Leave it as it is. The consequences can be big and the benefit is really small.