Topic: MySQL Connection Problems

[hayesbro2]

Hi I just installed SME Server 6.0.1

I installed phpmyadmin 2.6.0-alpha 2 to manager my databases.  I am trying to install some CMS but when after trying several I get the error "could not connect to the database."  This is a fresh install of SME and I am having it connect to localhost using my admin username and pass.  Any ideas on what I need to do?  Thanks.

[Boris]

First of all alpha release is not for use and may not work.
Second, before you connect your application to mySQL you need to create database for it and account in mySQL with sufficient rights to that database for your application.
Should be some instructions with CMS you trying to install.

[hayesbro2]

I have created the database and have also created a new mysql user.  Although in the CMS installation script it cannot connect to the database.  This is actually the 2nd time I've used the 6.0.1 distro (I've been trying several distros) and it worked fine the first time.  I'm not surre what I'm doing wrong or if I've forgotten something.  Any help would be appreciated.  Thanks!

[ergozd]

MySQL root password is LOOONG one and stored in

# /root/.my.cnf

Install Nightspirits phpmyadmin contrib
http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.5.6-3.noarch.rpm
 
and create another MySQL user with admin rights.

You can also run

Code: [Select]

/sbin/e-smith/config show mysqld
mysqld=service
    LocalNetworkingOnly=yes
    status=enabled


to see your mysql configuration

[raem]

What about this from the 6.0 release notes

The mysql database daemon is configured by default to accept only local connections (i.e. it is not accessible via the network).
This is a security precaution. We only use mysql for webmail preferences, and only require access from localhost.

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

[gallo_miguel]

In this case, what can I do to have Mysql working, reciebing queries from apache/php from my primari site.

I have SME server 5.6

Thanks in advance.


Miguel Gallo

[tenoca]

I can't connect to mysql remotely, I did a port scan to my server and port 3306 is not open.  How can I open this port?  Are there any upgraded versions of server-manager that will allow me to control mysql?

Thanks

[ergozd]

Ray answered your question above

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

[alejandro]

probably you need to restart mysqld to activate your changes

try "service mysqld restart" on your sme box prompt
after creating , giving permissions and so.

as additional info:
 Many mysql related db appliations are provided with some "file.sql" containing he whole instructions (automated) to create the database, tables, permissions, connections etc between "app" and mysql.
this file can be copied into sql section of "phpmyadmin"  to get everything done.
then restart de daemon (mysqld) and that's it.