Hi FT, Thats because you specified the wrong host in the syntax below:
mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password' with grant option; Try it again with the correct hostid (the one you are using with phpmyadmin) or put a wildcard like % for the mysql> GRANT ALL ON *.* TO 'root'@'%' indentified by 'my_password' with grant option; Best regards Nils Valentin Tokyo/Japan 2003年 8月 8日 金曜日 13:59、FT さんは書きました: > Thanks Nils, > > Now that phpmyadmin is working ..I can do just about everything on my > db...but when I try to log on on the server by typing : myself ....it > still gives me the error 1045 access denied for user root @ localhost > (using password:NO) > > I am a bit confused on why it does work from phpmyadmin on the client side > but not from the server...? > any idea? > > Fabrice > ----- Original Message ----- > From: "Nils Valentin" <[EMAIL PROTECTED]> > To: "FT" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, August 04, 2003 9:51 AM > Subject: Re: Root > > > Hi FT, > > 2003年 8月 4日 月曜日 09:24、あなたは書きました: > > Thanks Nils...good to have you around...in Tokyo > > This worked except for the UPDATE than was not recognized by MySql > > 3.23.36 > > > but strangely all previous tables were still there and it looks like it > > is running again.. still worry about this UPDATE command ..but I am back > > on phpMyAdmin 4.3.0 as root @ localhost > > How do I change this one or do I need to keep it.... > > Well that depends if you use the account local (login on the same machine > the > server is running ) or not. > > See the Grant command and the usage of the mysql client for details. Here > just > a rough sample: > > mysql> GRANT ALL ON *.* TO '[EMAIL PROTECTED]' indentified by 'my_password' > with grant option; > > If the user doesn't need to create new users than you can leave "with grant > option". > > Best regards > Nils Valentin > Tokyo/Japan > > > Thanks > > ----- Original Message ----- > > From: "Nils Valentin" <[EMAIL PROTECTED]> > > To: "FT" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Sunday, August 03, 2003 3:11 PM > > Subject: Re: Root > > > > > > Hi there, > > > > First shutdown the running server. > > > > mysqladmin shutdown > > or > > /etc/init.d/mysql.server stop > > or > > /etc/init.d/mysqld stop > > > > (depending on your Linux distribution) > > > > > > Then restart the mysql server with option "--skip-grant-tables" like > > this. > > > safe_mysqld --skip-grant-tables > > > > You can then login without password. And then you reset your password > > with > > > the update command like this: > > > > UPDATE user SET password='' WHERE user='root'; > > > > Restart the server again. > > > > Set a new password with mysqladmin like this: > > > > mysqladmin -u root password xxx > > mysqladmin -u root flush-privileges > > > > (xxx is your new password) > > That should be it. > > > > Mysql has a nice manual by the way where it is all described detailed, > > comes in very handy to have such a print close, just in case ;-) > > > > Best regards > > > > Nils Valentin > > Tokyo/Japan > > > > 2003年 8月 3日 日曜日 14:21、FT さんは書きました: > > > Hi everyone > > > I am quiet new to DB and MySql > > > I must have made a big mistake by changing the root @ localhost > > > password via phpMyAdmin and now it is impossible to connect from > > > neither the > > mysql > > > > prompt nor phpMyAdmin... > > > > > > Does anyone know how to recover this problem...I did try to reinstall > > > > MySql > > > > > after uninstalling it and rebooted the server but no luck so far... > > > > > > Thanks for the hand > > > > > > Fabrice > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]