DaemonForums  

Go Back   DaemonForums > OpenBSD > OpenBSD Packages and Ports

OpenBSD Packages and Ports Installation and upgrading of packages and ports on OpenBSD.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   (View Single Post)  
Old 4th January 2013
ershiba ershiba is offline
Loading, please wait...
 
Join Date: Dec 2012
Posts: 34
Thanked 0 Times in 0 Posts
Default [solved] phpMyAdmin - #2002 Cannot log in to the MySQL server

hi,,
let me described a bit what i have done,

1. clean install OpenBSD with X sets
2. add php-5.3.14p1, phpMyAdmin-3.4.10.2, mysql-server-5.1.63p0 and their dependencies.
3.
Code:
$ sudo nano /etc/rc.conf.local
mysqld_flasg=""
httpd_flags=""
pkg_scripts="mysqld"

$ sudo /usr/local/bin/mysql_install_db
$ sudo /usr/local/bin/mysql_secure_installation
4. setting phpMyAdmin link
Code:
$ cd htdocs/
$ sudo ln -s ../phpMyAdmin/ /var/www/htdocs/phpMyAdmin
5. i got 2 NIC on this virtual OpenBSD
Code:
$ ifconfig em0
em0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 1500
        lladdr 08:00:27:a7:7a:af
        priority: 0
        groups: egress
        media: Ethernet autoselect (1000baseT full-duplex)
        status: active
        inet6 fe80::a00:27ff:fea7:7aaf%em0 prefixlen 64 scopeid 0x1
        inet 10.0.2.15 netmask 0xffffff00 broadcast 10.0.2.255
$ ifconfig em1
em1: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 1500
        lladdr 08:00:27:77:6e:08
        priority: 0
        media: Ethernet autoselect (1000baseT full-duplex)
        status: active
        inet 192.168.56.200 netmask 0xffffff00 broadcast 192.168.56.255
        inet6 fe80::a00:27ff:fe77:6e08%em1 prefixlen 64 scopeid 0x2
6. i sshd into my virtual OpenBSD using OBSD user name "oem" and i created a mysql user name "oem" too. i could use console mysql -u root -p and console mysql -p (when ssh using putty)
Code:
mysql> select User, Host, Password FROM mysql.user;
+------+-----------+-------------------------------------------+
| User | Host      | Password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *######################################## |
| oem  | %         | *######################################## |
| root | 127.0.0.1 |                                           |
+------+-----------+-------------------------------------------+
3 rows in set (0.00 sec)
i change the original password here to ### as display for security purpose.

7. i use http://192.168.56.200/phpMyAdmin and try to log in the
first attempt would direct my to http://vmobsdx.my.domain/phpMyAdmin/
i don't have valid hostname yet, i just dummy fill one, should i change it to localhost?
Code:
$ hostname
vmobsdx.my.domain
8. second attempt http://192.168.56.200/phpMyAdmin would displays the Welcome to phpMyAdmin, fill in username and password,

i tried the mysql root user and mysql oem user with their respective password (not the OpenBSD password) but received the following error,
#2002 Cannot log in to the MySQL server

that is pretty much how i reach to this error, any advice?
thank you.

Last edited by ershiba; 6th January 2013 at 06:12 AM. Reason: problem solved, thanks a lot!
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
phpMyAdmin problems werwer OpenBSD General 5 16th July 2010 10:53 AM
Mysql server instaliaton from ports edvinus OpenBSD Packages and Ports 2 23rd June 2009 11:46 AM
problem phpmyadmin Nk2Network OpenBSD Packages and Ports 6 14th May 2009 08:15 PM
phpMyAdmin Unaccessable Nk2Network OpenBSD Packages and Ports 2 20th April 2009 09:13 PM
Mysql-server adventures in 4.3 ai-danno OpenBSD Packages and Ports 6 12th June 2008 05:01 PM


All times are GMT. The time now is 01:30 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick