Setting MySQL root password

keegan

I have a very frustrating problem:

I am administering a new RedHat server and the hosting company has installed a virtual hosting package which includes MySQL. They can't seem to tell me what the MySQL root password is, and it isn't blank.

How can I set it? I can log is as root, but even when I do MySQL says "Access denied for user: 'root@localhost' (using password: NO)". I tried to shut down mysql using "mysql stop" and "mysqladmin shutdown" but it still tells me Access denied.

What can I do??

Keegan

ingooellers

Hm. Getting the harder way....

Be sure that there are no data-writing processes in progress and kill the processes via Unix-Shell command

kill -9 [processnumber]

Get the processnumber via 'ps -ax | grep mysql'

You need a copy of the mysql-data files
in the main-directory of the mysql.

Install the mysql-Package in another location (or another server) and copy the raw files mysql/mysql.* in the new location.

Regards
Ingo