![]() |
Stupid question : How to create a MY SQL database
How to create a MySQL database under windows . Trying to install v bulletin on a windows machine . Never done that b4.
|
install php and mysql on it.
|
Download MySQL, install it - set it all up...then download phpmyadmin (www.phpmyadmin.net)...I reccomend using Apache (www.apache.org) for the web server... and of course you will need PHP (www.php.net)...then you're set!
|
I already got everything I need installed. What I need is too create a database.
|
mysql> create database x;
mysql> show databases; mysql> grant all on x.* to drdre identified by 'hellyeah'; ? |
from your admin cpanel or whatever you are using you might have access to phpMyAdmin... that is easiest way for you to create a database.
if not then open up a php page in your browser and put that code in : mysql_query("CREATE TABLE my_table"); |
/usr/local/mysql/bin/mysql -u root -p
create database databasenamegoeshere; GRANT SELECT,ALTER,INSERT,UPDATE,DELETE,CREATE,DROP ON databasenamegoeshere.* TO usernamegoeshere@localhost IDENTIFIED BY 'passwordgoeshere'; |
| All times are GMT -7. The time now is 02:55 PM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123