OK, one more stupid questions:

Is there any way I can reset the whole server so that it restore the default softwares and settings?? And no, I was not clever enough to backup the data before messing up the whole system!

i think thats something you want to email them about. btw, let us know the responses so i can take caution when doing things

I asked the Terra-Byte about this 07:25 CET. I have also sent a explaining what I have done (messed up the whole system while trying to install MySQL) to Steve 08.45. I have also asked Steve about this 11.50 when he informed me about the extra IP-pakkage i've ordered, but without getting any response.

Now it is 18.16 CET and no response!

I think they charge $50 to reset the server back to its orginal settings.

What is actually wrong with ur server?. You maybe able to repair it without a cost.

I simply don't know. It is just messed up. OK here's the deal:

1. I tried to install .pkg file for MySQL but could get any response, so I tried to install it manually.. tried to follow Kevin's tutoral.
2. I tried to istall MySQL to /usr/bin/mysql, but seems like it is install to /bin
3. I could not first access to MySQL database as root got some "Access denied" message.
4. No I can't connect to MySQL at all

This is what I want to do: just start from the scratch and try first to install .pgz file for MySQL and install PHP manually!

I'm new at this, didn't know that this could be soooo hard!

You shouldn't need a clean install of the RAQ software to correct a messed up MySQL installation. Have you rebooted the server since you installed MySQL? Chances are you have to startup MySQL manually eachtime you reboot at present.

Depending where you installed MySQL, you start the server with the following command in telnet:

/usr/local/mysql/bin/safe_mysqld &

Once you got it running again, you need to set a root password. This command sets a root password (again modify the line based on where you installed MySQL):

/usr/local/mysql/bin/mysqladmin -u root password 'password'

Now to connect to the server, use the following command:

mysql -u root -p

You'll be prompted for your password now. Enter it correctly and it will connect you to the mysql server.

The easiest way to learn how to interact with mysql is to follow the documentation on http://www.mysql.com and to just play around with creating databases, granting permissions etc.

Hopefully this helps. Its all based on the presumption you rebooted hoping it would solve your problem and now mysql isnt running at all.

Getting this

[admin@www admin]$ su
Password:
[root@www admin]# /bin
sh: /bin: is a directory
[root@www admin]# safe_mysqld &
[1] 19099
[root@www admin]# Starting mysqld daemon with databases from /var/lib/mysql
mysqld daemon ended
mysqladmin -u root password ****
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql
.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex
ists!
[1]+ Done safe_mysqld

Don't SU and try the other steps again ;-)