View Single Post
  #5  
Old 24th February 2011, 02:00
Bashewa Bashewa is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Ok I have done that, but still receive a

#1045 Cannot log in to the MySQL server error

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| c1test1 |
| dbispconfig |
| mysql |
+--------------------+
4 rows in set (0.00 sec)

The c1test1 db is what I created and cannot log into


Below done after doing #bind-address = 127.0.0.1 at mysql/my.cnf

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 *:ftp *:* LISTEN 30386/pure-ftpd (SE
tcp 0 0 41.72.149.230:domain *:* LISTEN 29413/named
tcp 0 0 41.72.149.229:domain *:* LISTEN 29413/named
tcp 0 0 server1.booknsta:domain *:* LISTEN 29413/named
tcp 0 0 localhost:domain *:* LISTEN 29413/named
tcp 0 0 *:ssh *:* LISTEN 30110/sshd
tcp 0 0 localhost:953 *:* LISTEN 29413/named
tcp 0 0 *:smtp *:* LISTEN 26410/smtpd
tcp 0 0 localhost:10024 *:* LISTEN 28539/amavisd (mast
tcp 0 0 localhost:10025 *:* LISTEN 28453/master
tcp 0 0 *:mysql *:* LISTEN 26602/mysqld
tcp 0 0 localhost:48158 localhost:domain TIME_WAIT -
tcp 1 0 localhost:50462 localhost:mysql CLOSE_WAIT 30223/amavisd (ch15
tcp 1 0 localhost:41943 localhost:mysql CLOSE_WAIT 30573/amavisd (ch15
tcp 0 0 localhost:mysql localhost:50462 FIN_WAIT2 -
tcp 0 0 localhost:57973 localhost:ftp TIME_WAIT -
tcp 0 52 server1.booknstay.c:ssh 41-134-160-57.dsl.:3611 ESTABLISHED 26348/0
tcp 0 0 localhost:42744 localhost:www TIME_WAIT -
tcp 0 0 server1.booknstay.c:ssh 41-134-160-57.dsl:57621 ESTABLISHED 26345/sshd: root@no
tcp 0 0 localhost:mysql localhost:41943 FIN_WAIT2 -
tcp6 0 0 [::]op3 [::]:* LISTEN 29323/couriertcpd
tcp6 0 0 [::]:imap2 [::]:* LISTEN 29295/couriertcpd
tcp6 0 0 [::]:http-alt [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:www [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:tproxy [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:ftp [::]:* LISTEN 30386/pure-ftpd (SE
tcp6 0 0 [::]:domain [::]:* LISTEN 29413/named
tcp6 0 0 [::]:ssh [::]:* LISTEN 30110/sshd
tcp6 0 0 ip6-localhost:953 [::]:* LISTEN 29413/named
tcp6 0 0 [::]:https [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:imaps [::]:* LISTEN 29312/couriertcpd
tcp6 0 0 [::]op3s [::]:* LISTEN 29340/couriertcpd
tcp6 0 0 41.72.149.229%32159:www adsl-36-0-47.asm.:50734 ESTABLISHED 26145/apache2
tcp6 0 0 41.72.149.229%32159:www adsl-36-0-47.asm.:50740 ESTABLISHED 26245/apache2
tcp6 0 924 41.72.149.229%32159:www adsl-36-0-47.asm.:50737 ESTABLISHED 26246/apache2
tcp6 0 0 41.72.149.229%32159:www adsl-36-0-47.asm.:50745 ESTABLISHED 26243/apache2
tcp6 0 0 41.72.149.229%32159:www llf320049.crawl.y:48890 TIME_WAIT -
tcp6 0 1190 41.72.149.229%32159:www adsl-36-0-47.asm.:50735 ESTABLISHED 26267/apache2
tcp6 0 5748 41.72.149.229%32159:www adsl-36-0-47.asm.:50736 ESTABLISHED 26277/apache2
tcp6 0 0 41.72.149.229%32159:www crawl-66-249-71-1:52333 ESTABLISHED 26044/apache2
tcp6 0 0 41.72.149.229%32159:www llf320049.crawl.y:51543 TIME_WAIT -
Reply With Quote