This is my first lamp server. I am pretty excited about the results so far, but i ran into some problems. I am running Ubuntu Lamp server 6.0.6 LTS and i followign the directions step by step. http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p2 As you can tell from the image below, I get an error error: 'Host 'server1.(MYDOMAIN).com' is not allowed to connect to this MySQL server' I am assuming for the directions, not meaning sound noobish but we DO replace the mysqlpassword with your own in the command line. Correct? I have registered my domain and have it pointed it my static ip. I use a router which i have my server exposed through the dmz. I can access ssh anywhere. as well as the default apache page... any help will be much appreciatted! BTW Falko your howto is amazingly thorough!
in case this helps in case this helps... OUTPUT: netstat -tap tcp 0 0 *:mysql *:* LISTEN - tcp 0 0 192.168.0.103:domain *:* LISTEN - tcp 0 0 localhost.locald:domain *:* LISTEN - tcp 0 0 localhost.localdoma:953 *:* LISTEN - tcp6 0 0 *:www *:* LISTEN - tcp6 0 0 *:ssh *:* LISTEN - tcp6 0 0 ip6-localhost:953 *:* LISTEN - tcp6 0 576 ::ffff:192.168.0.10:ssh server1.<mydomain>:62587 ESTABLISHED- OUTPUT: ps aux | grep mysql root 4240 0.0 0.2 3696 1468 ? S 14:23 0:00 /bin/sh /usr/bin/mysqld_safe mysql 4301 0.0 3.3 126444 17056 ? Sl 14:23 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock root 4302 0.0 0.1 2656 732 ? S 14:23 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld admin 4589 0.0 0.1 2880 796 pts/0 R+ 23:22 0:00 grep mysql
http://www.howtoforge.com/forums/showthread.php?t=7228&highlight=mysqladmin+server1.example.com I found out the answer! falko : Quote: Originally Posted by oakleeman I've been trying to follow the Centos setup guide and am having the mysql password problem. Almost all of the ISPConfig tutorials have the following commands which numerous people have problems with: mysqladmin -u root password yourrootsqlpassword mysqladmin -h server1.example.com -u root password yourrootsqlpassword The first command should work without problems. If you have problems with the second one, it's because there is another hostname than server1.example.com in the mysql.users table. You can forget about this now and correct it later with phpMyAdmin. Restart MySQL afterwards.
