http://www.mysql.com/doc/D/e/Default_privileges.html shell> mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; mysql> FLUSH PRIVILEGES; > -----Original Message----- > From: h3rb [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 07, 2001 1:00 AM > To: [EMAIL PROTECTED] > 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 >
