ok, so i paid $30 to set up mySQL, now what?

[clubmedia.com]

should i be able to see the database physically on my web space? i am trying to set up an ikonboard.com forum, which will be using the mySQL database, so i need to know how to access it and where exactly it is. can someone please lead me in the right direction. i don't seem to see it in my control panel, should i have all the info somewhere in there on it? if so i can't seem to find it

[sophiespo]

You will not be able to "see" your database in your webspace. You will need a program that will connect to it, like Macson (a popular one) or you need to install a php script called phpMyAdmin to your website. These will allow you to view the tables in your database and perform queries on them.

If youre installing ikonboard and having it use MySql, you dont any of the above programs. All you need is the name of the server your database is on (i.e. venus.powweb.com or terra.powweb.com, etc) the name of your database, and the username and password to access it. If you dont know this information you can find it in OPS (https://ops.powweb.com) click on packages and then click on MySql

sophie

[clubmedia.com]

thanks. i looked all in there and don't have any info at all about it. i set it up last week, so could they just not have completed the database set-up?

[sophiespo]

Definitely. When I ordered my database it was set up straight away. Did you recieve any emails about it? Is there anything about MySql in your OPS? Does it show your database with a user listed when you click on the MySql tab? If there isnt and you know you definitely ordered MySql then you better send an email to support@powweb.com

sophie

[Starr]

There are no emails that go out for mySQL activation. You handle it all right there from Ops.

Once you order mySQL, if you reload your domains package area, you will see your new mySQL tab. Just click on that tab and you will be able to add up to 3 unique users to manage your database.

[clubmedia.com]

found out the problem. the database name has to be completely unique on the server. if not it won't go through. it would be convenient if the screen said that for future users trying the same thing. by i got mysql now baby!!! thanks for all your help!

[Berek Halfhand]

I set one up last night. Took all of 30 seconds to do. It is a gotcha that it has to be unique to the whole server including the other mysql websites. That also includes the database administrator. One of the disadvantages of virtual hosts..... Plus if you use a sql front end you can see all the other databases on the server. Interesting....

Oh yeah, it's all in the FAQ.