Hello Folks, I've been trying to configure Ubuntu Server 6.06 according to the "perfect setup" guide here: http://www.howtoforge.net/perfect_setup_ubuntu_6.06_p4 I'm running into trouble configuring MYSQL. I'm at the portion of the tutorial where I'm trying to specify a password for user root. I start by typing this command: mysqladmin -u root password yourrootsqlpassword That works fine. But when I type the following command: mysqladmin -h server1.example.com -u root password yourrootsqlpassword I get an error about my server not being allowed access. Has anyone come across this before? Note that the above entry is an example. I've replaced my FQDN and actual password when actually doing this. Thanks.
Hi thecgmguy, I'm no expert here, but I seem to recall having a similar issue while I was installing Debian on my machine. I didn't report it here since it was not the first item on my priority list at the time and was intending to install ISPConfig (which I knew would test it later). When I had ISPConfig loaded, I use phpMyAdmin to edit the MySQL privileges table and gave the appropriate rights to the root account. After that, I was able to login using root. Cheers, Nap
Have a look here: http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com http://www.howtoforge.com/forums/showthread.php?t=4640&highlight=mysqladmin+server1.example.com http://www.howtoforge.com/forums/showthread.php?t=5877&highlight=mysqladmin+server1.example.com http://www.howtoforge.com/forums/showthread.php?t=4709&highlight=mysqladmin+server1.example.com
Thanks for the prompt replies guys. Could I get clarification on what exactly these mysql commands are doing? Thanks.
yeah I get the same error edgy eft but.. Code: root@server1:~# cat /etc/mysql/my.cnf | grep bin #bind-address = 127.0.0.1 log_bin = /var/log/mysql/mysql-bin.log # WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian! max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name root@server1:~# cat /etc/hosts 127.0.0.1 localhost 10.0.0.69 server1.local.lan root@server1:~# ping server1.local.lan PING server1.local.lan (10.0.0.69) 56(84) bytes of data. 64 bytes from server1.local.lan (10.0.0.69): icmp_seq=1 ttl=64 time=0.099 ms root@server1:~# mysqladmin -h server1.local.lan -u root password XXXX mysqladmin: connect to server at 'server1.local.lan' failed error: 'Access denied for user 'root'@'server1.local.lan' (using password: NO) root@server1:~# netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 localhost:2464 *:* LISTEN 3758/python tcp 0 0 localhost:2208 *:* LISTEN 3755/hpiod tcp 0 0 *:imaps *:* LISTEN 8147/couriertcpd tcp 0 0 *:pop3s *:* LISTEN 8039/couriertcpd tcp 0 0 *:mysql *:* LISTEN 22150/mysqld tcp 0 0 localhost:63629 *:* LISTEN 4409/wish its running...
Please make sure you follow this tutorial as close as possible: http://www.howtoforge.com/perfect_setup_ubuntu_6.10
They are doing nothing wrong, but your hostname is not as it should be, so there's a wrong hostname in the mysql.user table, that's why Code: mysqladmin -h server1.example.com ... doesn't work.
