My first server.. mysql. problems /w Ubuntu Lamp Server

Discussion in 'Installation/Configuration' started by mwburris, Mar 19, 2007.

  1. mwburris

    mwburris New Member

    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.

    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!

  2. mwburris

    mwburris New Member

    in case this helps

    in case this helps...

    OUTPUT: netstat -tap

    tcp 0 0 *:mysql *:* LISTEN -
    tcp 0 0 *:* 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: server1.<mydomain>:62587 ESTABLISHED-

    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/ --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
    Last edited: Mar 20, 2007
  3. mwburris

    mwburris New Member

    I found out the answer!

    falko :
    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 -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 in the mysql.users table. You can forget about this now and correct it later with phpMyAdmin. Restart MySQL afterwards.

Share This Page