MySQL Forums
Forum List  »  Newbie

Re: Problem in account creation
Posted by: Felix Geerinckx
Date: June 06, 2005 03:10AM

Aski babu wrote:

> I m very new to Mysql environment as now i have installed and configured Mysql
> server 4.1. Its working fine.

> mysql>CREATE USER javauser IDENTIFIED BY 'javasoft' WITH GRANT OPTION;
> ERROR 1064(42000):YOU HAVE AN ERROR IN SQLSYNTAX;

CREATE USER is available from MySQL 5.0.2 onwards. (see http://dev.mysql.com/doc/mysql/en/create-user.html)

You can use GRANT however (see http://dev.mysql.com/doc/mysql/en/grant.html)

> i also what to know whether stored procedures are in Mysqlserver 4.1.

You need MySQL 5 for stored procedures as well

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
June 06, 2005 01:12AM
Re: Problem in account creation
June 06, 2005 03:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.