Re: MySQL permission
From: Timothy Murphy (tim_at_birdsnest.maths.tcd.ie)
Date: 05/26/05
- Next message: bahhab_at_hotmail.com: "locate - Permission denied"
- Previous message: Baruch: "Re: Linux Fails The Family Test BADLY!"
- In reply to: Dave Uhring: "Re: MySQL permission"
- Next in thread: Dave Uhring: "Re: MySQL permission"
- Reply: Dave Uhring: "Re: MySQL permission"
- Reply: Joe: "Re: MySQL permission"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 26 May 2005 12:39:39 +0100
Dave Uhring wrote:
> If you had bothered to read and implement the instructions presented to
> you after installing the initial database you would not have this problem.
>
> echo "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !"
> echo "This is done with:"
> echo "$bindir/mysqladmin -u root password 'new-password'"
> echo "$bindir/mysqladmin -u root -h $hostname password 'new-password'"
> echo "See the manual for more instructions."
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 password 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 password 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.
Are root on the MySQL machine and root@martha.murphy.ie
completely unrelated users, or is there some relation between them?
I have the following conversation on alfred (the server machine):
==========================================
[tim@alfred ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 77 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all privileges on *.* to tim@martha.murphy.ie
identified by 'tim';
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
==========================================
Am I right in thinking that this will give user tim
on the client machine access to everything on the server?
-- Timothy Murphy e-mail (<80k only): tim /at/ birdsnest.maths.tcd.ie tel: +353-86-2336090, +353-1-2842366 s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland
- Next message: bahhab_at_hotmail.com: "locate - Permission denied"
- Previous message: Baruch: "Re: Linux Fails The Family Test BADLY!"
- In reply to: Dave Uhring: "Re: MySQL permission"
- Next in thread: Dave Uhring: "Re: MySQL permission"
- Reply: Dave Uhring: "Re: MySQL permission"
- Reply: Joe: "Re: MySQL permission"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
