Hi, No I have not have MySql installed before and I am using version 1.4, but I used an my.cnf from another host with mysql 3.x
Now I can't even manage to start it I get the following in the log file 040224 14:39:01 mysqld started 040224 14:39:04 InnoDB: Started 040224 14:39:04 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 040224 14:39:04 Aborting 040224 14:39:04 InnoDB: Starting shutdown... 040224 14:39:06 InnoDB: Shutdown completed 040224 14:39:06 /usr/sbin/mysqld-max: Shutdown Complete 040224 14:39:07 mysqld ended After installing it the first time I did not manage to log in as root to change the password. Is there some way to reset everything uninstall mysql and start all over from the beginning again? Best Regards /maria -----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: den 24 februari 2004 11:15 To: [EMAIL PROTECTED] Subject: Re: install problem "Maria Yndefors" <[EMAIL PROTECTED]> wrote: > Hi, Thanks for the fast reply, > > I have not set the root password and I get the same result > > [EMAIL PROTECTED] gms]# mysql -u root -p > Enter password: > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > NO) > Do you have installed MySQL server before? Seems MySQL server uses old data dir. You can reset root password: start MySQL server with --skip-grant-tables option, set up new password for root and restart MySQL server or just reload privilege tables. More detailed instruction you can find at: http://www.mysql.com/doc/en/Resetting_permissions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]