Re: Problems with mysql

Eric Teuber wrote:

Gerald I. Evenden wrote:
I am having a problem with enabling non-root users in
mysql. As and example:

create database xxx;

generates and error:

ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'xxx'

which is interesting because of the empty user field. In the same
session, 'status' shows the user to be 'gie@localhost' and
'mysql -u root' shows 'gie@localhost' to be in the 'mysql.users'
table. The gie user was added with "ALL PRIVELEGES."

I did run the script 'mysql_fix_privilege_tables' mentioned in the
mysql reference manual and rebooted. No difference.

Suggestions greatly appreciated.

i had the same problem a few months ago. If i correctly remember
creating the user in mysql with quotes 'name'@'localhost' instead of
name@localhost solved the problem. Have a try.

HTH
Eric

Basically you are correct but it took me some time to figure
out what was happening in the mysql.user table. One record
had "name@localhost" entirely in the name field. I think they
confused the issue with the odd syntax of the ''@'' rather than
referring to the User and Host fields in a normal manner.

Thanks for the hint.
.

Relevant Pages

  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • Re: php script to create mySQL database programmatically
    ... "Jerry Stuckle wrote: ... hosting configuration may not allow create database from script, ... You can make a script to create a database. ... Can't connect to local MySQL server through socket ...
    (comp.lang.php)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: toolkits or APIs to create a web interface as a frontend to mysql
    ... I am also *not* looking for a web based full fledged mysql client. ... For simple display of tabulated data the most useful thing is a displaywhich uses 's with absolute coordinates to position text in a box of defined width, formatted to be left, right or center justified, an using a preselected style from a a style sheet. ... As far as the actual database calls go, those are specific to each form, and apart from a little coding so that 'database_open, database_close' exist in the library, taking such things as the database name, user name and password from an included file I find it easiest to simply do the query and iterate through it to display the data requested. ...
    (comp.os.linux.misc)