Need Help With PHPMyAdmin!

Question

Level 1

1 points

Need Help With PHPMyAdmin!

Hi,

I'm following along with this tutorial for installing PHPMyAdmin:

http://www.adobe.com/devnet/dreamweaver/articles/settingup_php04.html

Per Step 8, when I go to

http://localhost/phpmyadmin/setup/index.php

I get this:

Bzip2
Bzip2 compression and decompression requires functions (bzopen, bzcompress) which are unavailable on this system.

ZIP
Zip decompression requires functions (zip_open) which are unavailable on this system.
Insecure connection

Force SSL connection
This option should be enabled if your web server supports it

Servers
There are no configured servers

Anyone have any idea what the heck I'm doing wrong?

Thank you.

MacBook Pro, Mac OS X (10.5.8)

Posted on Feb 7, 2010 12:51 PM

Reply

Answer 1

MJN1812 Author

Level 1

1 points

Feb 8, 2010 7:30 PM in response to MJN1812

Correction -

Right below that is GNU nano 2.0.1 File: /etc/my. cnf

Reply

Answer 2

Feb 8, 2010 8:19 PM in response to MJN1812

MJN1812 wrote:
Did the sudo nano, control "o", then control "x", but I'm not sure if it's quit nano.

The top of the terminal window says Terminal - sudo - 80x24
Right below that is GNU nano 2.0.1 File: /etc/my.cn

Big blank space, then

File name to Write: /etc/my.cnf

Right below that is

^G Get Help ^T To Files M-M Mac Format M-P Prepend
^C Cancel M-D DOS Format M-A Append M-B Backup File

Does that look right?

You're close. You have to hit the "enter" key after you hit control-"o", when you see " File Name to Write: /etc/my.cnf".

charlie

Reply

Answer 3

MJN1812 Author

Level 1

1 points

Feb 9, 2010 9:29 AM in response to Charles Minow

Entered

*bbedit -** /Library/LaunchDaemons/com.mysql.mysqld.plist*

Got

*bbedit: /Library/LaunchDaemons/com.mysql.mysqld.plist: Permission denied*

Reply

Answer 4

Feb 9, 2010 6:15 PM in response to MJN1812

MJN1812 wrote:
Entered

*bbedit -** /Library/LaunchDaemons/com.mysql.mysqld.plist*

Got

*bbedit: /Library/LaunchDaemons/com.mysql.mysqld.plist: Permission denied*

Obviously, BBEdit is not able to create files like that. I thought it could. So, instead of " bbedit -**", use nano like you did before when BBEdit wouldn't create a file in a protected directory:

sudo nano /Library/LaunchDaemons/com.mysql.mysqld.plist

Then continue on with the instructions.

charlie

Reply

Answer 5

MJN1812 Author

Level 1

1 points

Feb 9, 2010 7:39 PM in response to Charles Minow

Did step 5, and this is what I got:

ERROR 1045 (28000): Access denied for user 'myname'@'localhost' (using password: NO)

Reply

Answer 6

MJN1812 Author

Level 1

1 points

Feb 9, 2010 7:44 PM in response to Charles Minow

And looking at the response from rerunning Step 1, I got more than 2 lines:

_mysql 92515 0.1 0.4 2739968 18124 ?? S 10:32PM 0:00.23 /usr/local/mysql-5.1.43-osx10.5-x86_64/bin/mysqld --basedir=/usr/local/mysql-5.1.43-osx10.5-x86_64 --datadir=/usr/local/mysql-5.1.43-osx10.5-x86_64/data --log-error=/usr/local/mysql-5.1.43-osx10.5-x86_64/data/c-xx-xxx-xxx-xxx.hsd1.x x.comcast.net.err --pid-file=/usr/local/mysql-5.1.43-osx10.5-x86_64/data/c-xx-xxx-xxx-xxx.hsd1.xx .comcast.net.pid --socket=/tmp/mysql.sock
_mysql 92465 0.0 0.0 75884 704 ?? Ss 10:32PM 0:00.03 /bin/sh /usr/local/mysql/bin/mysqld_safe

Reply

Answer 7

Feb 9, 2010 8:28 PM in response to MJN1812

Excellent news:

MJN1812 wrote:
Did step 5, and this is what I got:

ERROR 1045 (28000): Access denied for user 'myname'@'localhost' (using password: NO)

This and the two lines you got from the other command I had you run means you got the database daemon up and running. The error you see here means that when you tried to connect to the daemon you were denied access because the user 'myname'@'localhost' doesn't have sufficient privileges. In this case it's probably because you don't have a user called 'myname' set up.

However, MySQL has a root user, a little like OS X does, though it's a completely different user. See what happens if you try to connect as the MySQL root user:

/usr/local/mysql/bin/mysql -u root

At this point, you ought to be able to use PHPMyAdmin or Sequel Pro to connect, too. Just use "root" as the username and leave the password blank.

You'll want to set up a root password for MySQL soon, and users with their own passwords. Particularly when you start storing data you care about.

Now that you have the daemon running, you should be able to use just about any MySQL tutorial out there (and there are lots and lots), since it's pretty much the identical on any platform once you're actually dealing with the SQL stuff. I write all the code for my web sites on my laptop, but when I upload it to the servers, which are running MySQL on Linux, I don't have to change anything. All the MySQL stuff just works.

charlie

Reply

Answer 8

MJN1812 Author

Level 1

1 points

Feb 10, 2010 5:13 AM in response to Charles Minow

Entered:

/usr/local/mysql/bin/mysql -u root

Got:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I checked MySQL via the prefPane, and it's running. However, when I tried to stop it via that same prefPane, I still get the spinning rainbow. I had to force quit out of system preferences.

I tried logging in at phpMyAdMin, and still get the 2002 error code about the socket.

Reply

Answer 9

Feb 10, 2010 6:31 AM in response to MJN1812

MJN1812 wrote:
Entered:

/usr/local/mysql/bin/mysql -u root

Got:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

You've got still got permissions issues. And turn off any firewalls on your computer, too. Run these commands:

cd /usr/local/mysql
ls -l

Post your results. Also, look at the permissions for the "data" directory:

drwxr-x--- 25 _mysql wheel 850 Feb 7 02:39 data

If the ownership is anything but _mysql:wheel<?tt>, change it like this: sudo chown -R _mysql:wheel /usr/local/mysq/data

I checked MySQL via the prefPane, and it's running. However, when I tried to stop it via that same prefPane, I still get the spinning rainbow. I had to force quit out of system preferences.

My advice is to just give up on the Preferences Pane. I never had any luck with it, and long ago abandoned any idea of using it. Just use the Terminal: sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysqld.plist Wait 20 or 30 seconds for it to stop. If you really want a GUI solution for starting and stopping MySQL, then I suggest looking at XAMPP. It's going to be much easier to set up. In fact, you might find XAMPP easier anyway, as you seem to be really struggling with the "do it yourself" route. I'd also suggest getting a hardware router/firewall so your computer isn't connected directly to the cable modem. That way your servers won't be visible to the internet. Strictly read, Comcast's terms of use don't allow servers. In practice, they don't seem to get too excited about them unless they interfere with other people's connections, i.e., too much traffic.

I tried logging in at phpMyAdMin, and still get the 2002 error code about the socket.

Did you stop and restart the Apache server (Personal Web Sharing) after you made the edits to your PHP ini file? If not then do that and try again (of course, this won't work if you've already shut down MySQL).

charlie

Reply

Answer 10

MJN1812 Author

Level 1

1 points

Feb 10, 2010 8:03 AM in response to Charles Minow

-rw-r--r-- 1 root wheel 19071 Jan 15 15:38 COPYING
-rw-r--r-- 1 root wheel 5139 Jan 15 15:38 EXCEPTIONS-CLIENT
-rw-r--r-- 1 root wheel 9439 Jan 15 15:38 INSTALL-BINARY
-rw-r--r-- 1 root wheel 62989 Jan 15 15:38 README
drwxr-xr-x 46 root wheel 1564 Feb 8 16:50 bin
drwxr-x--- 9 _mysql wheel 306 Feb 9 22:32 data
drwxr-xr-x 4 root wheel 136 Jan 15 15:37 docs
drwxr-xr-x 34 root wheel 1156 Jan 15 15:37 include
drwxr-xr-x 22 root wheel 748 Feb 6 15:34 lib
drwxr-xr-x 4 root wheel 136 Jan 15 15:37 man
drwxr-xr-x 15 root wheel 510 Jan 15 15:38 mysql-test
drwxr-xr-x 3 root wheel 102 Jan 15 15:38 scripts
drwxr-xr-x 35 root wheel 1190 Jan 15 15:38 share
drwxr-xr-x 29 root wheel 986 Jan 15 15:38 sql-bench
drwxr-xr-x 16 root wheel 544 Jan 15 15:38 support-files

Entered:

drwxr-x--- 25 _mysql wheel 850 Feb 7 02:39 data

Got:

-bash: drwxr-x---: command not found

Reply

Answer 11

MJN1812 Author

Level 1

1 points

Feb 10, 2010 10:30 AM in response to Charles Minow

Perhaps, I should go w/either XAMPP or Sequel Pro.

But wouldn't going w/Sequel Pro still require getting MySQL running properly?

And if I go w/XAMPP, wouldn't I have to undo all that's already been done, i.e. uninstalling MySQL, etc?

Reply

Answer 12

MJN1812 Author

Level 1

1 points

Feb 10, 2010 11:09 AM in response to Charles Minow

Didn't know if step 6 would work, but thought I'd try for the heck of it.

Entered:

*sudo cp /etc/php.ini /etc/php.ini.backup-20100108*

Asked for my password.

Entered:

*sudo /etc/php.ini.default /etc/php.ini*

Got:

*sudo: /etc/php.ini.default: command not found*

Reply

Answer 13

Feb 10, 2010 6:22 PM in response to MJN1812

MJN1812 wrote:
Didn't know if step 6 would work, but thought I'd try for the heck of it.

Entered:

*sudo cp /etc/php.ini /etc/php.ini.backup-20100108*

Asked for my password.

Right, I guess I should have mentioned that, but for some reason, I thought you understood more about using Unix command in the Terminal. But anytime you use sudo before a comment (like cp), you'll be asked for your password. sudo is a way to preface other commands so you can do them as another user. In this case, as the root user.

Entered:

*sudo /etc/php.ini.default /etc/php.ini*

Got:

*sudo: /etc/php.ini.default: command not found*

Right, because /etc/php.ini.default isn't a command, but a configuration file.

charlie

Reply

Answer 14

MJN1812 Author

Level 1

1 points

Feb 10, 2010 7:03 PM in response to Charles Minow

Well, I entered my password, and gave me a new (shell?),

And then

Entered:

sudo /etc/php.ini.default /etc/php.ini

Got:

sudo: /etc/php.ini.default: command not found

And still have the permissions issues:

cd /usr/local/mysql
ls –l

-rw-r--r-- 1 root wheel 19071 Jan 15 15:38 COPYING
-rw-r--r-- 1 root wheel 5139 Jan 15 15:38 EXCEPTIONS-CLIENT
-rw-r--r-- 1 root wheel 9439 Jan 15 15:38 INSTALL-BINARY
-rw-r--r-- 1 root wheel 62989 Jan 15 15:38 README
drwxr-xr-x 46 root wheel 1564 Feb 8 16:50 bin
drwxr-x--- 9 _mysql wheel 306 Feb 9 22:32 data
drwxr-xr-x 4 root wheel 136 Jan 15 15:37 docs
drwxr-xr-x 34 root wheel 1156 Jan 15 15:37 include
drwxr-xr-x 22 root wheel 748 Feb 6 15:34 lib
drwxr-xr-x 4 root wheel 136 Jan 15 15:37 man
drwxr-xr-x 15 root wheel 510 Jan 15 15:38 mysql-test
drwxr-xr-x 3 root wheel 102 Jan 15 15:38 scripts
drwxr-xr-x 35 root wheel 1190 Jan 15 15:38 share
drwxr-xr-x 29 root wheel 986 Jan 15 15:38 sql-bench
drwxr-xr-x 16 root wheel 544 Jan 15 15:38 support-files

Entered:

drwxr-x--- 25 _mysql wheel 850 Feb 7 02:39 data

Got:

-bash: drwxr-x---: command not found

Reply

Answer 15

MJN1812 Author

Level 1

1 points

Feb 10, 2010 7:18 PM in response to Charles Minow

If I go w/XAMPP, will that override/replace all that I've done as far as MySQL, PHP, etc., are concerned? Or will I have to do some uninstalling?

Reply