Re: How to configure mysql server?

On Thu, 22 Jun 2006 03:42:30 +0100 Timothy Murphy <tim@xxxxxxxxxxxxxxxxxxxxxx>
wrote:

I'd like to run mysqld on my desktop "alfred"
and run a mysql client on my laptop "elizabeth".

It seems I need to grant permission on alfred
for tim@elizabeth to access the server,
but I have not found how to do this.

I'm running mysqld version 5.0.22 under Fedora-5.

When I try to set the password for user "root" on my desktop
I get the error:
------------------------------------------
[root@alfred tim]# mysqladmin -u root password whatever
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
------------------------------------------
Another attempt fails:
------------------------------------------
[root@alfred tim]# mysql -h localhost -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
------------------------------------------

Does this mean that "root" already has a password, which I do not know?

The only user I can login as is "mysql",
but then I can do little:
------------------------------------------
[tim@alfred ~]$ mysql -u sql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.22

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

mysql> grant all privileges on *.* to tim@elizabeth ;
ERROR 1045 (28000): Access denied for user ''@'localhost' (using password:
NO)
mysql> quit;
Bye
------------------------------------------

Could some kind guru tell me the solution to my quandary?

Try this:
$ mysql -u root

As a default root does not have a password. You have to change the root
password after you install it the first time.

Will

Attachment: signature.asc
Description: PGP signature

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

Relevant Pages

  • Re: Datenbank von "Aussen" erreichen ?
    ... > auf einem Server - per rpm oder gleich mittels Yast oder apt-get. ... > Nach dem Handbuch ist der System Root nicht der mySQL Root. ... > should assign passwords to the accounts created by mysql_install_db. ...
    (de.comp.datenbanken.mysql)
  • MYSQL - After install
    ... Stopping MySQL database server: mysqld. ... mysqladmin Ver 8.41 Distrib 5.0.22, ...
    (Ubuntu)
  • [Full-Disclosure] Proofpoint Protection Server remote MySQL root user vulnerability
    ... The MySQL server may be remotely access by the "root" user without using ... The Proofpoint Protection Server is a software product to filter spam ... the embedded MySQL 4.0 server binds to the default port ... Remote root will not be able to FLUSH ...
    (Full-Disclosure)
  • Re: INSTALAÇÃO DEBIAN LAMP!
    ... You should only use english in this list. ... >acessar o MySql e diz que eu não tenho permissão para acesso (isso pq eu ... >estou como ROOT). ... Sin importar el usuario, si quieres entrar a mysql como root, ...
    (Debian-User)
  • Re: Need Help setting up Mysql on Openserver 6.0
    ... >> Essentially the same as included with the SCO Doc server. ... > the Root Password... ... Stopping mysql ... ... SET PASSWORD FOR 'root'@'localhost' = PASSWORD; ...
    (comp.unix.sco.misc)