Outpost Universe Forums

Off Topic => General Interest => Topic started by: dm-horus on March 02, 2006, 03:38:00 AM

Title: Phpmyadmin
Post by: dm-horus on March 02, 2006, 03:38:00 AM

Ive flooded irc with my questions enough...

Im using phpmyadmin and ive got NO idea how to run queries. mysql administrator wont work on my lappy so i cant use that. what im looking for is a noob guide to running sql queries. to be brief, i need to figure out what i need to know to create a database, create users and set permissions. ive got an empty db going right now but ive got no idea how to create a mysql username so that y site can use it.

any help would be greatly appreciated.

Title: Phpmyadmin
Post by: Eddy-B on March 02, 2006, 06:48:38 AM

sqlcourse.com (http://www.sqlcourse.com)  (beginners)
sqlcourse2.com (http://www.sqlcourse2.com)  (advanced)
that's all you need to know.
Also check mysql.com


PS: ur welcome

Title: Phpmyadmin
Post by: BlackBox on March 02, 2006, 03:12:26 PM

After you selected a DB from the left pane, press the "SQL" tab at the top of the right pane and then input the query you want to run.

Hope that helps :)

Title: Phpmyadmin
Post by: dm-horus on March 02, 2006, 04:51:10 PM

ty all. the problem turned out to be twofold: first, my original db was inaccessible due to opu hosting issues and second, the hostname changed on the new db without my notice. ive got it all working very smoothly now.

the tips were helpful