Re: [PHP] phpMyAdmin is this possible
I always create a database by hand. On the console type: mysql -u root -p (It will prompt you for the mysql superuser's password. Then run: CREATE DATABASE db_name_here; Then you would use the grant statement accordly to give users permissions to it. Adam On Tue, 20 Aug 2002, Steve Jackson wrote: I am new to MySQL and PHP. Having looked at PHPMyAdmin the GUI I was wondering if it's possible to create a new database within the system? If so what are the commands? I ask because I only have one database on my server and don't want to populate it with different tables, I'd rather have seperate ones for seperate functions.. Ideas or advice? is the way I am suggesting better or worse than the way my hosting company expects me to work? Thanks in advance. Steve. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] phpMyAdmin is this possible
I am new to MySQL and PHP. Having looked at PHPMyAdmin the GUI I was wondering if it's possible to create a new database within the system? If so what are the commands? I ask because I only have one database on my server and don't want to populate it with different tables, I'd rather have seperate ones for seperate functions.. Ideas or advice? is the way I am suggesting better or worse than the way my hosting company expects me to work? Thanks in advance. Steve. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] phpMyAdmin is this possible
Do you have phpMyAdmin running yet? If so you create new databases with the click of a button. The first page you see should say Welcome to phpMyAdmin ...ver etc. If you have set phpMyAdmin to run on an existing MySQL install, the drop down boxes should contain your existing databases if configured correctly. To create a new database just type the name in the box on the home page and click create, from there you can create new tables etc. hth Steve. -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 3:12 PM To: MYSQL; Php-General Subject: [PHP] phpMyAdmin is this possible I am new to MySQL and PHP. Having looked at PHPMyAdmin the GUI I was wondering if it's possible to create a new database within the system? If so what are the commands? I ask because I only have one database on my server and don't want to populate it with different tables, I'd rather have seperate ones for seperate functions.. Ideas or advice? is the way I am suggesting better or worse than the way my hosting company expects me to work? Thanks in advance. Steve. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php