On Tue, 11 Apr 2000, John P. Looney wrote:
> On Tue, Apr 11, 2000 at 01:36:25PM +0100, John P. Looney mentioned:
> > Ack. How do I add a user to Mysql. I've a user;
> > Any idea what could be wrong ?
>> Mutter. I've been using Oracle too long. Forgot you've to restart the
> database for it to take effect...
I'm reading a backlog so this might have been answered already. Forgive me
if it has
Handiest way is to
GRANT ALL PRIVILEGES on database.* TO user at localhost IDENTIFIED BY 'user'
WITH GRANT OPTION;
GRANT ALL PRIVILEGES on databas.* TO user@% IDENTIFIED BY 'user' WITH
UPDATE user SET Password = password('testpass') where User ='user';
You don't need to restart the database.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!