Pages: [1]   Go Down

Author Topic: Phpmyadmin  (Read 1557 times)

Offline dm-horus

  • Banned
  • Hero Member
  • *****
  • Posts: 1042
Phpmyadmin
« 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.
Logged

Offline Eddy-B

  • Hero Member
  • *****
  • Posts: 1186
    • http://www.eddy-b.com
Phpmyadmin
« Reply #1 on: March 02, 2006, 06:48:38 AM »
sqlcourse.com  (beginners)
sqlcourse2.com  (advanced)
that's all you need to know.
Also check mysql.com


PS: ur welcome
« Last Edit: March 02, 2006, 06:48:59 AM by Eddy-B »
Logged
Rule #1:  Eddy is always right
Rule #2: If you think he's wrong, see rule #1
--------------------

Outpost : Renegades - Eddy-B.com - Electronics Pit[/siz

Offline BlackBox

  • Administrator
  • Hero Member
  • *****
  • Posts: 3093
Phpmyadmin
« Reply #2 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 :)
Logged

Offline dm-horus

  • Banned
  • Hero Member
  • *****
  • Posts: 1042
Phpmyadmin
« Reply #3 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
Logged
Pages: [1]   Go Up