Trying to setup a web server with Redhat 7.1 / Perl / PHP and MySQL. I've gotten PHP, Telnet, and FTP running fine, but I've been through absolute hell trying to figure out the MySQL installation.

RPM:
I select all the MySQL options during the CD installation process.

CONFIGURATION:
The CD Install is done (for the 45th time), and I setup all the other services I want by commenting and uncommenting conf files. I come to MySQL...

shell: /var/lib/mysql/mysql_install_db

-->

Installing all prepared tables

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

______________

Great, right ?

shell: /usr/bin/safe_mysqld &

-->

starting mysqld daemon with databases from /var/lib/mysql
010917 01:35:43 mysqld ended

______________

It died. I go to the log file

shell: /var/log/mysql/ tail 100 mysqld.log

->

/usr/libexec/mysqld: Can't find file: '.mysql/host.frm' (errno: 13)

______________

I think I need to setup permissions, but I can't do it, MySQL won't let me in.

I've logged in as root, I've got no idea what to do now, I'm in pain. I'm going blind looking at the manual.

PLEASE HELP ME!!
Rob.

No, all that stuff is done or already setup in RedHat 7.1

Install all the MySQL RPMs from the RedHat CD and startup MySQL:

/etc/rc.d/init.d/mysqld start

To make it permanent there are various ways, easiest for me is "ntsysv" which gives a text-based menu where you can select various services to turn on/off.

Do "mysqladmin password your_new_password" and it should set the root password to that. Might have to restart MySQL after that.

Done, works, ready to go...

Remember, start things using the init.d scripts when you can instead of manually...

Thanks for the info - I did a clean install again, and got it running... you're right, I didn't need to do anything other than start it up. Someone emailed me a "setup" command which brought up the menu which allowed me to check off what services to use at startup. What the heck is that, and where is that from? It worked, and easy to remember...

Thanks so much!