Greetings Jonathan,
There are a couple of ways that you can add a user. the best way is to grant
that user permissions on an existing database. If the user does not exist
then it will be created. That's the way I do it because then I don't have to
beg my ISP for insert/update permissions on the mysql database. I'm not sure
how to delete a user this way, maybe someone can chime in and help us both
out.
If you have CrUD permissions on the mysql database then you can add the
users manually by inserting them into the user table in the mysql database.
Since I've not delved into the complexities of the host table and the db
table, I don't usually do it this way. But you can do it, just remember to
FLUSH PRIVILEGES when done or the changes won't take effect. (Which usually
has the effect of driving you insane until you remember to do it.)
I've worked with MS SQL and Oracle (just a little bit, not much) and I can
say that once I understood how to do it, I really like it.
Have you looked at one of the GUIs, Webmin or phpMyAdmin?
HTH,
Cal
http://www.calevans.com
-----Original Message-----
From: Jonathan Dugan [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 03, 2001 5:33 PM
To: [EMAIL PROTECTED]
Subject: <synopsis of the problem (one line)>
>Description:
Unclear documentation on how user permissions work. I've been using
databases for about a year and have experience with Postgres and Oracle.
How do I add a new user?? How do permission work?? I've spent an hour now
and I still get:
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
>How-To-Repeat:
Install MySQL.
>Fix:
Better documentation.
>Submitter-Id: <submitter ID>
>Originator: Jonathan Dugan
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.22.25 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on
i686
TCX Datakonsult AB, by Monty
Server version 3.22.25
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 16 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open
tables: 2
>Environment:
System: Linux iscb.stanford.edu 2.2.16-3smp #1 SMP Mon Jun 19 19:00:35 EDT
2000 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from
/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exce
ptions -fno-rtti' LDFLAGS=''
Configure command:
./configure --enable-shared --enable-assembler --with-mysqld-user=mysql --w
ith-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstated
ir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/us
r/man
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
