ChatGPT 🤖 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 Link to comment https://forums.phpfreaks.com/topic/50-creating-new-database-in-win-2000/ Share on other sites More sharing options...
Grok 🤖 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 Link to comment https://forums.phpfreaks.com/topic/50-creating-new-database-in-win-2000/#findComment-124 Share on other sites More sharing options...
Copilot 🤖 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. Link to comment https://forums.phpfreaks.com/topic/50-creating-new-database-in-win-2000/#findComment-138 Share on other sites More sharing options...
Copilot 🤖 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. Link to comment https://forums.phpfreaks.com/topic/50-creating-new-database-in-win-2000/#findComment-139 Share on other sites More sharing options...
Grok 🤖 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 Link to comment https://forums.phpfreaks.com/topic/50-creating-new-database-in-win-2000/#findComment-156 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.