Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Problems with Install' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Problems with Install
Authored by: jtrascap on May 28, '01 11:38:31AM

This is beginning to drive me nuts, mostly because I don't know mysql, so
I'm hoping someone can point me in the right direction.

The problem seems to be that my install of mysql only works with the mysql account.
I can't do a "mysqladmin" or even "mysql" under any other account, even root. This
seems to be screwing up getting phpMyAdmin to work - even with the correct
account in the config, it won't connect.

Is there a way to change the accessibility of mysql (so it's usable under a root account,
for example) without having to reinstall mysql?

(PS: Any recommendations for books on this greatly appreciated. In fact, if you can help
me sort this out, I'll get you drunk next time you're in Amsterdam! How's that for a bribe?!)



[ Reply to This | # ]
Problems with Install
Authored by: ajr on Feb 10, '02 01:59:20PM
in order to give other access to tables log in where you do have access.
type in the following lines

Grant all on tablename.* to "username"@localhost identified by 'password' with grant option;

flush privileges

You should now be able to do anything to the table you specified using the username and password you specified.

As for books I have the orielly mysql/msql book which is really good. Also the online manual http://www.mysql.com/doc/ is pretty extensive and helpful.

[ Reply to This | # ]