Thanks for your reponses but I tried both of the suggestions below and still had problems.
I killed mysql and then I used "/etc/init.d/mysql start" I was able to use mysql --user=mysql and get into mysql However when I tried to create a database I get "ERROR 1044: Access denied for user: '@localhost' to database mydata " If I try mysql --user=root then I get "ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)" Then after killing the process again I tried the next suggestion of I still cannot do mysql_install_db since it seems to shutdown the second I entered the command but I think this step is neccessary to set up the grant tables. I then proceed anyways to /usr/bin/safe_mysqld --user=root --password=YOURPASS & However I don't user a password as it seems that it does not recognize the variable --password. It then says Starting mysqld-max daemon with databases from /var/lib mysql but hangs until I hit the enter key. I then try mysql --user=root and I get the Access denied 1045 error I can try as user mysql but still can't start it. What am I missing? Also, is it important restart the linux server if I have already killed the mysql processes? thanks very much Annie Law wrote:> > Hi,> > I would appreciate any help on the following. I have searched the mailing list for> information But have not come up with a solution for my situation which has been> frustrating. I think I need some things need to be clarified.> > The OS that is running is RedHat V.9.0 linux. MySQL was installed when RedHat V.9.0> was installed. Here are the packages that that I have installed> <snip>Annie,There should be a startup/stop script for mysql in /etc/init.d/ . Tryrunning"/etc/init.d/mysql stop"After that, check for mysql with "ps -eaf |grep -i mysq" . If you find aprocess running, try to kill it with "kill -15 pid". You may have to use"kill -9 pid" if the processes wont go away with -15. You should be ableto start mysql using "/etc/init.d/mysql start". Once the server isrunning, su to the mysql user and you should be able to log in to thedatabase using "mysql".walt ------------------------------------------------- Annie Law wrote:> First, I went to the MySQL website to look up the section> on Unix Post-installation Procedures. I then tried the> following as root and got the following result:>> ----------------------------------------------------------> ------------------------------------------------->> Shell> cd /usr/bin>> Shell> mysql_install_dbIf you do this as root then you only be able to start mysqldas root> To start mysqld at boot time you have to copy> support-files/mysql.server to the right place for your> systemRedHat has a init script for all the services that wereinstalled by anaconda, there is one for mysqld in/etc/rc.d/init.d, if you have configured mysql to star atthe boot time this script uses /etc/my.cnf for the user andpasswords needed to start mysqld.> You can start the MySQL daemon with:>> cd / ; /usr/bin/mysqld_safe &Again if you was root when did mysql_install_db then youshould do this to start mysqld if this wasn't started atboot time:------------------------------------------------------/usr/bin/safe_mysqld --user=root --password=YOURPASS &------------------------------------------------------If you are going to use mysql in a exposed server then isvery insecure run it as root.CheersUsuario Linux #323140celiseATprodigy.net.mx --------------------------------- Post your free ad now! Yahoo! Canada Personals
