|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
01-15-2004, 09:57 AM
|
#1 | |
|
Too lazy to set a custom title
Industry Role:
Join Date: Jan 2001
Posts: 51,692
|
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.
__________________
Quote:
|
|
|
|
|
01-15-2004, 10:00 AM
|
#2 |
|
hi
Industry Role:
Join Date: Jun 2002
Posts: 16,731
|
install php and mysql on it.
__________________
M3Server - NATS Hosting |
|
|
|
|
01-15-2004, 10:02 AM
|
#3 |
|
Confirmed User
Industry Role:
Join Date: Jun 2003
Location: Costa Rica
Posts: 1,953
|
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!
__________________
Yii Framework Guru - Seasoned PHP vet - Partner @ XXXCoupon.com |
|
|
|
|
01-15-2004, 10:04 AM
|
#4 | |
|
Too lazy to set a custom title
Industry Role:
Join Date: Jan 2001
Posts: 51,692
|
I already got everything I need installed. What I need is too create a database.
__________________
Quote:
|
|
|
|
|
|
01-15-2004, 01:08 PM
|
#5 |
|
Confirmed User
Industry Role:
Join Date: Oct 2002
Location: lalaland
Posts: 2,120
|
mysql> create database x;
mysql> show databases; mysql> grant all on x.* to drdre identified by 'hellyeah'; ? |
|
|
|
|
01-15-2004, 01:18 PM
|
#6 |
|
Confirmed User
Join Date: Jan 2003
Posts: 183
|
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");
__________________
Go Traffic Cash Gold !!! |
|
|
|
|
01-15-2004, 01:21 PM
|
#7 |
|
Confirmed User
Join Date: Nov 2002
Location: nyc
Posts: 3,540
|
/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'; |
|
|
|
