Terminal Posted January 15, 2003 Share Posted January 15, 2003 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 Quote Link to comment Share on other sites More sharing options...
Patrick Posted January 15, 2003 Share Posted January 15, 2003 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 Quote Link to comment Share on other sites More sharing options...
abubin Posted January 16, 2003 Share Posted January 16, 2003 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. Quote Link to comment Share on other sites More sharing options...
abubin Posted January 16, 2003 Share Posted January 16, 2003 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. Quote Link to comment Share on other sites More sharing options...
Patrick Posted January 17, 2003 Share Posted January 17, 2003 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.