SuSE

Hey,

I was wondering if anybody could help me setup my PhpMyAdmin on my SUSE linux 9.1 machine. I want to use it to access MySQL server instead of the defualt MySQLCC-Console Manager.
I have not tried yet but i have done a such and it's installed in one of the folders.
I would like to point out that i have not set up MySQL server yet; i guess i will have to set it up first?
Thanks for the help in advance.
Regards,
sybella.

More problems please help:

I have tried to register MySQL server to try and work in MySQLCC - Console manager and i'm getting the following error: "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' ". I have tried to change the sockect path to '/tmp/mysql.sock' but still get the same error message.

Any ideals on how to solve this problem plz?

Regards,

Paul

You need at least a MySQL client library on your server wanting to run phpMyAdmin. In this case, I generally install the server distribution which contains the client as well, but I install it without configuring any server stuff (boot config, database initialization, MySQL variables etc.)

Of course, if you want to administer a database server running on the same system you need a server configured also. If you just want to administer a remote system, you don't need a local server running.

So, from your error message seems like you are trying to connect to local MySQL server. So, has it been started? On the machine running the server, you can usually do a "netstat -tln" to check the list of ports listened on (Linux, may not be on Windows/other Unix OS). You should find "3306" if the server can be started.

Note that if you connect to a local MySQL server, the client and server socket paths should match!

And one more thing. In order for phpMyAdmin to work, your PHP should be compiled with mysql extension builtin and enabled. It needs access to the client library. For some recent MySQL releases it is claimed to be able to be compiled embedded, but I have not much experience with this.

CbKihong:

I want to administer mysql server running on the same machine; its running on the same suse linux 9.1.

I did a 'netstat -tln' and the only ports listened on are: (1056,2049,898,10025,10024,5801,139,111,631,25,953,445,53,22,25,953
). I couldn't find 3306; therefore i need to start the server, but how?

I would like to mention that i did a search and found that there is phpMyAdmin in the folders: usr/share/doc/packages/ and srv/www/htdocs/.

Plus i installed MySQL Server and phpMyAdmin from the DVD/CD that came with the SUSE linux 9.1

Thanks for your help
regards,
sybella.

MySQL server can be started in a number of ways. As I haven't used SuSE for several years I have forgotten the exact configuration it uses. But in general, here are some general possibilities:

(1) I think the SuSE MySQL server RPM comes with the startup script, so it will be automatically started on startup (if without errors). Look inside /etc/init.d for the startup script. It may be called 'mysql' or something like that. Then

/etc/init.d/mysql start

If it cannot be started, you may need to read the log file to see exactly what the problem is. I think the log files are kept in /var/log/mysql. You may need to really dig it out if it is not.

This is generally the preferred way of starting a MySQL server.

(2) You may also run the mysqld_safe executable directly. But this can be a bit tricky, and if you don't have much experience it is possible that this may lead to files created in improper ownerships which create problems for future if you are to start this way.

Before you do this, please verify you really have the MySQL server installed. With most Linux distributions, the MySQL server and client are put in separate packages and so it is possible that you have installed the client but not the server. If you have server installed you should find some executables (usually in /usr/bin) with the name 'mysqld' or 'mysqld_safe' which correspond to the MySQL server.

When I installed the MySQL RPM with SuSE 7.3 several years ago the server would not start out of the box, as it was found that the file ownership were incorrect. The docs at mysql.com is quite overwhelming, but is useful in tracking down problems and fixing the common ones.

Cbkihong thanks for your help.

This is what i have done: i have executed '/etc/init.d/mysql start'; which started mySQL service.

Then 'usr/bin/mysqladmin -u root password' to try and set up new password. It came up with connection to server at 'localhost' failed. Error: 'can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. Check that mysqld is running. How do i check its running?
I have also looked in 'var/lib/mysql/mysql.sock; it does exist but couldn't open it.

I have checked mysqld exists in 'usr/sbin'

regards,
sybella