MySQL permission 3709

Dave Uhring

I don't recall getting any such message on my system (Fedora-3). What exactly do you mean by "installing the initial database"? I just gave the command "sudo yum install mysql-server".

However, I have set a pbuttword for root on my MySQL server (alfred), and have not had any problems on that score.

On the other hand, I have had problems setting a pbuttword for root on the machine (martha) which I am using to access the server.

I take it the second mysqladmin above is intended for this purpose? It seems to me incidentally that there should be some explanation if two different commands are given. Are they meant to be alternatives? Do you consider that to be obvious?

For some reason that is not clear to me, I cannot just give the name of the machine "martha" as $hostname, nor can I give the IP address (192.168.3.6) although the documentation seems to suggest I can. I have to give the name "martha.murphy.ie", the last part being a domain name I invented at some point long ago when some piece of software required me to give it. The command "hostname" just returns "martha", so I am not really sure where MySQL got the "full" domain name from. However, that is the least of my worries.

Some queries I have. completely unrelated users, or is there some relation between them?

I have the following conversation on alfred (the server machine): ========================================== Enter pbuttword: Welcome to the MySQL monitor. Commands end with ; org. Your MySQL connection id is 77 to server version: 3.23.58

Type 'help;' or '-h' for help. Type '-c' to clear the buffer.

identified by 'tim'; Query OK, 0 rows affected (0.00 sec)

Bye ==========================================

Am I right in thinking that this will give user tim on the client machine access to everything on the server?

-- Timothy Murphy tel: +353-86-2336090, +353-1-2842366 s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland