I have added some extra fields to the mysql.user table, namely:
full_name VARCHAR(255)
job VARCHAR(255)
location VARCHAR(255)
phone VARCHAR(255)
reminder VARCHAR(255) NOT NULL
ip_addr VARCHAR(255) NOT NULL
I want to store these values for each person that creates a new account on my database.
The database is still in production test mode, so I was adding some "dummy" users.
The statement to create the account is:
"INSERT into user (
Host,
User,
Password,
full_name,
job,
location,
phone,
reminder,
coreID,
ip_addr
)
VALUES ('%','yessir',PASSWORD('yesyesyes'),'Nathan
Lanier','Yes-man','FL-SE','123-1234','yesyesyes','161.161.1.131')"
I kept getting "Access Denied" errors for this user. I scoured the newsgroup archives
for this problem, and tried every bit of advice on MySQL.com's documentation under
4.2.10, and nothing helped. I restarted the mysqld, and nothing helped. I needed to
make sure that I could still create new users, so, I tried:
"INSERT into user (
Host,
User,
Password,
full_name,
job,
location,
phone,
reminder,
coreID,
ip_addr
)
VALUES ('%','newUser',PASSWORD('yesyesyes'),'Nathan
Lanier','','','','yesyesyes','161.161.1.131')"
This one works perfectly. I narrowed the problem down to the job column, so I deleted
the value for user 'yessir'. It worked! In order to then figure out why some
accounts with values in the job column work and user 'yessir' didn't, I tried various
values for the job column. Thinking it was the hyphen, I put in "Yesman" and it
worked! But, I have another user with 'Heave-ho' as it's job and that one works fine.
So, it's not the hyphen. Very strange.
I think that the "Yes-" is throwing it off. But, if that was so, why can I change the
"reminder" column, on the same account, to be "Yes-yesyes" and the account still
works? Is there some limitation to using the keyword "job"? The column "full_name"
resides before "job" in the table, so I don't think that it's conflicting with the
order of the priviledge columns.
Any ideas would be appreciated so that I can make sure that some unsuspecting user
doesn't throw some value in their entry that will cause the system not to work for
them. Or maybe there's a better way of going about this?
Nicholas Hamlin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
