Creating new database in win 2000
Posted 15 January 2003 - 03:31 AM
How can I create a new MySQL database in Windows 2000? MySQL and PHP is installed, I just don\'t know where to begin.
Thank you for any help
Posted 15 January 2003 - 04:21 AM
I\'ve found the easiest way to manage MySQL is by using phpMyAdmin, see www.phpMyAdmin.net - free download - just extract to your document root, and access index.php. If you\'d rather use the MySQL command prompt open the command prompt and select c:INSTALLATION_PATHmysqlbin then type: mysql -u \'username\' -p or just: mysql -u root if you haven\'t changed the root password yet. (phpMyAdmin makes it much easier)
I start by building the database in phpMyAdmin and then starting on the php code from there.
Hope that helps,
Posted 16 January 2003 - 06:11 AM
Once I installed mysql, there are no shortcuts created in the startmenu to allow me to run mysql. I have to run it from mysql \"bin\" folder. But there are like 2 dozens of .exe files there which I am not sure which one to execute.
I downloaded mysql control center from mysql site. But the problem is, this program didn\'t ask me to create a database. It directly ask for my parameters to connect to the database which I have no idea.
Thanks in advance.
Posted 16 January 2003 - 06:26 AM
I manage to login using \"root\" as the username and blank password. That must be the default username. I must have missed it from the doc. Thanks to this forum, found it after reading through some of the posting.
Posted 17 January 2003 - 02:07 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users