MYSQL - After install

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

MYSQL - After install

Patrick Newberry
Not sure but seemed to have problem in the set up  my root password:
...<snip>...
Setting up mysql-server-5.0 (5.0.22-0ubuntu6.06.2) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
.

<So far so good>

goshawk@gypsyfarm:~$ mysqladmin
mysqladmin  Ver 8.41 Distrib 5.0.22, for pc-linux-gnu on i486
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Administration program for the mysqld daemon....<snip>

<then try using xxxxxx as password in this example goshawk is the user I
am logged into ubuntu with>

goshawk@gypsyfarm:~$ mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'goshawk'@'localhost' (using password:
NO)'
goshawk@gypsyfarm:~$ mysqladmin -u root password xxxxxx

<then>
goshawk@gypsyfarm:~$ mysqladmin -h goshawk@localhost -u root -p password
xxxxxx Enter password:

mysqladmin: connect to server at 'goshawk@localhost' failed
error: 'Unknown MySQL server host 'goshawk@localhost' (2)'
Check that mysqld is running on goshawk@localhost and that the port is
3306.
You can check this by doing 'telnet goshawk@localhost 3306'
goshawk@gypsyfarm:~$ mysqladmin -h root@localhost -u root -p password
xxxxxx
Enter password:
mysqladmin: connect to server at 'root@localhost' failed
error: 'Unknown MySQL server host 'root@localhost' (2)'
Check that mysqld is running on root@localhost and that the port is
3306.
You can check this by doing 'telnet root@localhost 3306'
goshawk@gypsyfarm:~$ mysqladmin -h root@gypsyfarm -u root -p password
xxxxxx
Enter password:
mysqladmin: connect to server at 'root@gypsyfarm' failed
error: 'Unknown MySQL server host 'root@gypsyfarm' (2)'
Check that mysqld is running on root@gypsyfarm and that the port is
3306.
You can check this by doing 'telnet root@gypsyfarm 3306'
goshawk@gypsyfarm:~$ mysql restart
ERROR 1045 (28000): Access denied for user 'goshawk'@'localhost' (using
password: NO)
goshawk@gypsyfarm:~$ sudo mysql restart
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)


<try to ping again>
goshawk@gypsyfarm:~$ sudo mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'



<my machine name is gypsyfarm>
<just now wondering... Maybe I should be using root@gypsyfarm ?
Machine at home so can't try till tonight.>



Pat




--
ubuntu-users mailing list
[hidden email]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
Reply | Threaded
Open this post in threaded view
|

Re: MYSQL - After install

albi@scii.nl
On Fri, 22 Sep 2006 08:21:49 -0400
"Patrick Newberry" <[hidden email]> wrote:

> Not sure but seemed to have problem in the set up  my root password:

> goshawk@gypsyfarm:~$ mysqladmin -h goshawk@localhost -u root -p
> password xxxxxx Enter password:
>
> mysqladmin: connect to server at 'goshawk@localhost' failed
> error: 'Unknown MySQL server host 'goshawk@localhost' (2)'

try instead : mysql -h localhost -u root -p
or simply : mysql -u root -p

--
grtjs,
albi

--
ubuntu-users mailing list
[hidden email]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-users