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.
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
// hostname or ip of server
// username and password to log onto db server
// name of database