Re: cannot change 'root' user password

[Alejandro Silva]

Hi,

I'm getting a very similar error message in a very similar environment. In my case, I'm trying to create a table with:

CREATE TABLE `becene`.`tbl_student` (
`student_id` INT NOT NULL AUTO_INCREMENT,
`first_name` VARCHAR,
`last_name` VARCHAR,
PRIMARY KEY (`student_id`)
);

But I get the following error message:
Error executing SQL commands to create table.
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 '
`last_name` VARCHAR,
PRIMARY KEY (`student_id`)
)' at line 3 (error 1064)

I'm running MySQL 5.0.51b on Mac OS X 10.4.11 and I'm new to MySQL :-(

Alex