Sorry to bring this up again, but I'm still struggling with the syntax.
I am at the point where I have the server setup on static ip 192.168.10.222.
I have edited "my.cnf" so that it listens on all.
I have created a mysql admin account, and can log on to this prompt:
mysql>
When I try to enter a new user, and then grant privs like this (following
Marks tips):
mysql> CREATE USER 'user'@%' identified by 'staff';
'> GRANT ALL ON *.* TO 'c4p_user'@%';
I get this error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '%' identified by 'staff';
GRANT ALL ON *.* TO 'user'@%'' at line 1
My mistake is obviously syntax but I can't see where I am going wrong. The
docs supplied by MJ haven't helped much either at the moment although I am
sure they will when I get my head round this.
Any suggestions?
Stu
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Rogers
Sent: 22 December 2006 11:23
To: Peterborough LUG - No commercial posts
Subject: Re: [Peterboro] MySql Server in a Windows Domain
MJ Ray wrote:
> I don't like the 5.1 manual as much as some older versions. Am I
> imagining things or have they changed the manual styles recently?
> The 3.23 manual looks like the 5.1 now.
>
Don't know if you're imagining things but I've always found the MySQL
manual hard work to find my way around. The content is generally good
when I find what I'm after, though.
--
Mark Rogers
More Solutions Ltd :: 0845 45 89 555
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.26/597 - Release Date: 21/12/2006
18:45
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.26/597 - Release Date: 21/12/2006
18:45
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
