You can install phpMyAdmin in any location that apache can serve files from.
To add a new database in the command-line, you can, from the shell, run
or, from inside mysql:Code:mysqladmin -u root -p create <database_name>
Though you do not need to do it as the MySQL 'root' user, but as any user with create permissions.Code:create database <database_name>;
I must add that I despise phpMyAdmin and do almost all of my database manipulation in the shell. It keeps my brain fresh, especially for correctly and efficiently crafting queries for use in my php apps. If you're a sysadmin, I would recommend spending some more time in the Terminal and getting used to–and comfortable with–the shell.![]()




LinkBack URL
About LinkBacks
Reply With Quote


Bookmarks