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

Feb 10, 2010 8:52 PM in response to MJN1812

MJN1812 wrote:
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

Sorry, I just looked and it looks like I forgot the "cp" command:

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

That command will ask you for your password, then, once you give it, it will copy php.ini.default file to php.ini. Then you could edit it.

charlie

Reply

Answer 2

Feb 10, 2010 8:57 PM in response to MJN1812

MJN1812 wrote:
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?

You'd just need to make sure the MySQL you installed isn't running, and that Personal Web sharing is turned off in your System Preferences' Sharing pane. If those are turned off, you shouldn't have any problems with XAMPP.

If either of those are running, XAMPP will warn you that another server is running. Two programs can't bind to the same port. In other words, if the OS X Apache is running, the XAMPP Apache can't use the same port (80).

charlie

Reply

Answer 3

MJN1812 Author

Level 1

1 points

Feb 11, 2010 6:02 AM in response to Charles Minow

Got through

Now, save and close this file. You should stop and restart Apache. Once you do that, PHP should be able to connect to MySQL.

Tried to log in, and got

#1045 - Access denied for user 'myactualname'@'localhost' (using password: YES)

Reply

Answer 4

MJN1812 Author

Level 1

1 points

Feb 11, 2010 6:13 AM in response to Charles Minow

Read this on another forum - *In the forth line of code below, enter the password (between the single quotes) that you gave when you installed MySQL. The “User Name” defaults to 'root'*

And I remembered setting a password for the root, so I tried logging in to phpMyAdmin w/username 'root@localhost' and the password.

I got in, but now I get all this:

The additional features for working with linked tables have been deactivated. To find out why click here. When I clicked, this is what it said:

$cfg['Servers'][$i]['pmadb'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
General relation features: Disabled

$cfg['Servers'][$i]['table_info'] ... not OK [ Documentation ]
Display Features: Disabled

$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ... not OK [ Documentation ]
Creation of PDFs: Disabled

$cfg['Servers'][$i]['column_info'] ... not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled

$cfg['Servers'][$i]['bookmarktable'] ... not OK [ Documentation ]
Bookmarked SQL query: Disabled

$cfg['Servers'][$i]['history'] ... not OK [ Documentation ]
SQL history: Disabled

$cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ]
Designer: Disabled

Cannot load mcrypt extension. Please check your PHP configuration.

*This is the rest of the information I got when I first logged in:*

Cannot load mcrypt extension. Please check your PHP configuration.

The configuration file now needs a secret passphrase (blowfish_secret).

Directory config, which is used by the setup script, still exists in your phpMyAdmin directory. You should remove it once phpMyAdmin has been configured.

Your PHP MySQL library version 5.0.82 differs from your MySQL server version 5.1.43. This may cause unpredictable behavior.

Reply

Answer 5

Feb 11, 2010 6:13 AM in response to MJN1812

MJN1812 wrote:
Got through

Now, save and close this file. You should stop and restart Apache. Once you do that, PHP should be able to connect to MySQL.

Tried to log in, and got

#1045 - Access denied for user 'myactualname'@'localhost' (using password: YES)

You probably don't have a MySQL account for 'myactualname'. I get that error if I try to connect as a user that doesn't exist, or a user that exists but I give a bad password. When MySQL is initially set up, it doesn't have any users beyond "root" and "root" doesn't have a password. Try connecting to MySQL with the username of 'root' and no password.

charlie

Reply

Answer 6

MJN1812 Author

Level 1

1 points

Feb 11, 2010 6:34 AM in response to Charles Minow

I tried:

*mysql -u root -p*

Got:

*-bash: safe_mysqld: command not found*

Tried:

/usr/local/mysql/bin/mysql

Got:

*ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)*

Obviously, I'm doing something wrong.

Reply

Answer 7

Feb 11, 2010 6:56 AM in response to MJN1812

For those having problems with Apache/PHP/MySQL on Snow Leopard. This is a quick set of instructions for a clean install of Snow Leopard.

MySQL:

Download a copy of MySQL from dev.mysql.com

Run the main installer.
Run the StartupItem installer.
Install the PreferencePane.

MySQL will be accessible from the /usr/local/mysql directory. This is just a symbolic link. The main installation will be in the usr/local/mysql-<version>-<os>-<arch>

Open up your terminal, goto the /usr/local/mysql/bin directory and run the following command to set a root password for your MySQL installation:-

./mysqladmin -u root password whatever password_you_want_for_the_rootaccount

Apache:

1. Apache can be found in /etc/apache2
2. Feel free to make a copy of the configuration file that is found in that directory. Another copy of the original Apache config can be found in /etc/apache2/original
3. Modify the configuration file to enable php - it is disabled by default. Uncomment the LoadModule php5_module line and save the configuration.
4. Enter the /etc/apache2/other directory and create a file with a .conf extension. Call it anything you want and add the following lines to it:-

<IfModule php5_module>
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

<IfModule dir_module>
DirectoryIndex index.php index.html
</IfModule>
</IfModule>

PHP:

The default php configuration file is found in /etc. The name is php.ini.default. Make a copy of this file in the /etc directory and call it php.ini.

Modify it and make the following changes:-

Set the date.timezone value to your timezone.
Set the pdo_mysql.default value to /tmp.mysql.sock
Set the mysql.default_socket to /tmp/mysql.sock
Set the mysql.default_socket to /tmp/mysql.sock

Give Apache a restart and everything should be good to go.

Reply

Answer 8

Feb 11, 2010 6:59 PM in response to MJN1812

MJN1812 wrote:
The additional features for working with linked tables have been deactivated. To find out why click here. When I clicked, this is what it said:

$cfg['Servers'][$i]['pmadb'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
General relation features: Disabled

$cfg['Servers'][$i]['table_info'] ... not OK [ Documentation ]
Display Features: Disabled

$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ... not OK [ Documentation ]
Creation of PDFs: Disabled

$cfg['Servers'][$i]['column_info'] ... not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled

$cfg['Servers'][$i]['bookmarktable'] ... not OK [ Documentation ]
Bookmarked SQL query: Disabled

$cfg['Servers'][$i]['history'] ... not OK [ Documentation ]
SQL history: Disabled

$cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ]
Designer: Disabled

Now you're getting into areas I don't know much about. I would bet that the "Documentation" after each message is a link to more information about that. Have you looked at it to see what it says?

Your PHP MySQL library version 5.0.82 differs from your MySQL server version 5.1.43. This may cause unpredictable behavior.

That doesn't seem to be terribly important to me, especially for someone who's just starting out. My PHP MySQL library also doesn't match the version of MySQL I have installed and I haven't noticed any unpredictable behavior.

charlie

Reply

Answer 9

MJN1812 Author

Level 1

1 points

Feb 11, 2010 7:11 PM in response to Charles Minow

Okay. Noted.

I tried logging in as root user, but to no avail.

Tried:

mysql -u root -p

Got:

-bash: safe_mysqld: command not found

Tried:

/usr/local/mysql/bin/mysql

Got:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

What's the proper command for logging in as root user?

Reply

Answer 10

MJN1812 Author

Level 1

1 points

Feb 11, 2010 7:17 PM in response to Charles Minow

Or doesn't it matter if the mysql is running under root user?

I just find it odd that I can log in to phpmyadmin as root user, but can't use a command to log in to mysql as root user.

Reply

Answer 11

Feb 12, 2010 5:08 AM in response to MJN1812

The path to the MySQL bin directory is not included in your regular path so you'll have to run it straight from the directory.

Try doing:-

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

See if that works.

Reply

Answer 12

Feb 12, 2010 5:13 AM in response to MJN1812

For the missing features, have a look at this section of the documentation.

http://www.phpmyadmin.net/documentation/Documentation.html#linked-tables

Reply

Answer 13

MJN1812 Author

Level 1

1 points

Feb 12, 2010 5:39 AM in response to Felix Bowman

This is what I got, I'm assuming it means MySQL is now running as root user?

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is xx (xx represents a number that I wasn't sure should be posted or not)
Server version: 5.1.43 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

And is it better to keep it this way? For eventually, I'll be uploading some web sites to a web host, and just want to do it the right way.

Thank you!

Reply

Answer 14

Feb 12, 2010 6:30 AM in response to MJN1812

MJN1812 wrote:
This is what I got, I'm assuming it means MySQL is now running as root user?

It means you've logged in to MySQL as the root user. You're thinking about it somewhat backwards. MySQL is a multi-user database, and you set up those users in MySQL itself. Right now, you don't have any users set up, except for the root user. But you could set up different users with different levels of permissions.

Typically, I set up one user that has only INSERT, SELECT, UPDATE and DELETE privileges on a database's tables. For a web site, I might have another user that only has SELECT privileges on some databases or tables if there's no reason for that user to need to make changes to it.

And is it better to keep it this way? For eventually, I'll be uploading some web sites to a web host, and just want to do it the right way.

You're probably fine to keep it this way for now while you're just learning.

In the long run, though, you'll want to look at how your web host provider will allow you to organize your data. For example, if your web host gives you one database per site, it would make sense to have just one database for that site on your computer, so that when you upload it to the web host, it all stays the same. On the other hand, if you can have multiple databases per site, then you can organize your data accordingly.

charlie

Reply

Answer 15

Feb 15, 2010 4:50 AM in response to MJN1812

As the poster above your said, you're logged into MySQL as the root user of MySQL. On your operating system, MySQL usually runs as the user mysql. The root user in MySQL is the default administration account for the entire database.
Other users can be created with specific permissions set but to go down that road I think is another discussion all by itself.

Did you get your phpMyAdmin up and running? Can it now connect to your MySQL instance?

Reply