Hi FT,
2003年 8月 8日 金曜日 16:15、Nils Valentin さんは書きました: > 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; Just ralized that I gave you the wrong syntax. So for the record the correct syntax must be mysql> GRANT ALL ON *.* TO 'root'@'hostname' indentified by 'my_password' with grant option; Note that the username and hostname are in separated single quotes. Sorry for that confusion. Why did nobody correct me ??? never mind ;-) Best regards Nils Valentin Tokyo/Japan > > 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]
