Web Hosting Talk : Other Forums : Web Hosting Lounge : MySQL installation

[Nam]

I have this stupid question because I've never installed mySQL before. My host is tera-bytes.com (lucky that I had control over my dns or I'll wait for webexpose.net forever). Okay, I'm going to install PHP nuke. The install file says:

Change to the sql/ directory and there is a file called "nuke.sql" this file contains the commands to build the database structure, tables and the default data.

1) Create a database called, for example, nuke:
mysqladmin create nuke
2) Now fill the databases with the tables in nuke.sql file:
mysql nuke < nuke.sql
3) In order to use the File Manager, please be sure to chmod 666 ALL files and 777 ALL directories.

But I don't know how to make sql file and what is the directory. I asked tera-bytes and they replied:

a mysql db has been setup for you on the localhost.
Database Name: myusername
Database Username: myusername
Database Password: ***

to use the db:
mysql -u myusername -p
enter your password when prompted
mysql> use myusername
You can place your php files etc and run them from ant folder on your site.

Please help, what did they mean? where can I type the mysql -u myusername -p? How can I create the nuke file above? I'm clueless. Thank you so much for helping me.

[MSW]

You need to telnet into your account to do this.

[gthorley]

Nam
You probably figured this out already.
I haven't got mysql but while on a telnet to my account with tera-byte I entered mysql -u myusername -p and it asked for a password.

[Nam]

Thanks guys, I still haven't figured out yet, may be this question is so stupid that nobody bother to help.

I did try telnet, and it did ask my password, but my question is, what directory that created database would go to? How to link?

I've seen other webhosting that allow you to create mySQL in their control pannel, is that right? I think that is much easier than telnet, which I don't know much about it.

[BC]

Nam,

You're probably referring to the superb PHP utility phpMyAdmin, available at http://www.phpwizard.net/projects/phpMyAdmin/index.html

You can easily install it on your account (though I think Tera-Byte might already have it somewhere - check with them)...

[Chicken]

Originally posted by Nam
Thanks guys, I still haven't figured out yet, may be this question is so stupid that nobody bother to help.

I did try telnet, and it did ask my password, but my question is, what directory that created database would go to? How to link?

I've seen other webhosting that allow you to create mySQL in their control pannel, is that right? I think that is much easier than telnet, which I don't know much about it.

Ok, so you have a db, and a password now correct? You don't really have to worry about where it is. Now, you don't link to it- rahter you configure whatever it is that you are going to use the db for.

My vBulletin uses a config file something like this:

// only mysql is supported at the moment
$dbservertype="mysql";
// hostname or ip of server
$servername="localhost";
// username and password to log onto db server
$dbusername="***yourusername***";
$dbpassword="***yourpass***";
// name of database
$dbname="***nameofdb***";