MySQL permission 3710

Timothy Murphy

I gather this does the initial setup, though not the setting of root pbuttwords. This is also done for you by Debian.

They are effectively two different users and can have different pbuttwords. If you just ask for user root, e.g. mysql -u root -p, the the other one. The intention is that they should have the same pbuttword so that whether the hostname is given or not, the same things happen.

That depends on how name resolution is done. I have only a few machines so I make sure theetc-hosts file on each machine contains both the full domain name and hostname of all of them. This makes life a lot simpler. Windows machines have hosts files too.

Yes, they are unrelated, and that *is* a vital piece of information. I can remember trying to work out what the connection was between a Unix root user, aroot directory and a directory. Function overloading is a bad idea. Not sure. I've never seen the 'identified by tim' bit, and I think any update query that works gives a non-zero result for 'rows affected'.

Start interactive mode as root and check like this: show databases;

use mysql; show tables; select * from user;

To see a user and host list, just do: select user, host from user;

It's a lot easier with MySQLCC, for which there is a FC2 version which seems OK on FC3. Find it with your favourite RPM search.

Oh, by the way, if you specify a user from any machine on a network,