I have Apache, Php, mySQL, and the works installed on my machine.
I have created a mySQL database using the mySQL administrator and have done all the coding, etc.
I've moved the code over to the real server but don't have the foggiest idea how to set up the database on the server.
I'm unable to just move the files (mydatabase.frm, mydatabase.MYD, mydatabase.MYI) because i don't have permission to the folder. There is a database set up but now I need to recreate the tables on the database. I have the userid and password and was told that 'openssh' is installed or that I can create the table through telnet. This is where I don't have clue.
Couldn't I just connect to the database and then run the SQL code to recreate the talbes???
I tried this and got an error "MySQL Connection Failed", Host com' is not allowed to connect to this MySQL server..."
Any ideas on what to do??
I have created a mySQL database using the mySQL administrator and have done all the coding, etc.
I've moved the code over to the real server but don't have the foggiest idea how to set up the database on the server.
I'm unable to just move the files (mydatabase.frm, mydatabase.MYD, mydatabase.MYI) because i don't have permission to the folder. There is a database set up but now I need to recreate the tables on the database. I have the userid and password and was told that 'openssh' is installed or that I can create the table through telnet. This is where I don't have clue.
Couldn't I just connect to the database and then run the SQL code to recreate the talbes???
I tried this and got an error "MySQL Connection Failed", Host com' is not allowed to connect to this MySQL server..."
Any ideas on what to do??