It is not a problem with the user as such. You also have access rights. The default access is localhost. This means that you can only access mysql from the PC on which it is installed. There you have to use the mysql (i can't exactly rememer which utility) and change the user rights. It would go somewhere along the lines of this mysql> show databases; ... mysql> use mysql; ... mysql> show tables; ... mysql> select * from user; .... this will show you a table. You are interested in the first two columns. Host and User. You should have an user admin. The host is either localhost or the hostname of your linux pc. You need to do change this to %, which means any pc. (Don't forget to change this later to whatever suits your needs. mysql> update user set host='%' where user='root'; It will probably give an error ERROR 1062: Duplicate entry ..... Ignore this and do a :- mysql> select * from user; the first entry for root should now have the host set to % Have a look at the other tables maybe you need to change something there. I can't remeber, I'm old and stupid. You should now be able to access the server and login as root. I assume that you are using a bill gates super os powered pc to access your mysql box. If so I would recommend that you use MySQLFront to manipulate the MySQL server. It is 99% good 100% free software. Regards Phil. -----Original Message----- From: newbie-owner@linux-mandrake.com [mailto:newbie-owner@linux-mandrake.com]On Behalf Of h3rb Sent: Thursday, June 07, 2001 8:00 AM To: newbie@linux-mandrake.com Subject: [newbie] Mysql! How do I set the root password from a base install? How do I set the root password for mysql? I can't add any database's or anything cause it tells me that root@localhost is denied access. I switch to the user mysql and try to change the password that way. And mysql tell's me that the user mysql doesn't have permission to change passwords for other users. Could anyone point me in the right direction? I have gone to mysql.com and tried their solution to change a forgotton password. And that doesn't work either. I still can't connect to my database. I have setup mysql from scratch on other distro's. But this one with MDK8 is just about driving me nutz. h3rb --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.255 / Virus Database: 128 - Release Date: 17-May-01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.255 / Virus Database: 128 - Release Date: 17-May-01