Jump to content

Archived

This topic is now archived and is closed to further replies.

Terminal

Creating new database in win 2000

Recommended Posts

Hey,

 

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

Share this post


Link to post
Share on other sites

I have been running MySQL and an Apache Web server (with PHP installed as a module) as services on Win 2000 and it\'s been working well -althought I am having troubles with sessions and authentication.

 

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,

 

Patrick

Share this post


Link to post
Share on other sites

i am also having some problem getting mysql to work in windows 2000.

 

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.

Share this post


Link to post
Share on other sites

ah!! found it!!

 

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.

 

Thanks guys.

Share this post


Link to post
Share on other sites

Good on ya guys, consider using phpMyAdmin to manage your databases instead of using the command prompt - it does make life much easier. Just my opinion though...

 

Patrick

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.