Topic: MySQL in SME Server

[SoftGil]

Hi Everyone.

As far as I understood, MySQL is used internally for some purposes.

I would like to know how to access that database:

• Database Name
• Username
• Password
• Port to access it remotely (Standard 3306 ?)

Many thanks for your support.

Gil

[Mumm-Ra]

mysql can host many databases, each with a different name.
The best and easiest way to find out details of your mysql installation is to install phpmyadmin.  There is a contrib that you can install, then you view your databases over the web interface.
To access mysql on a sme server remotly you'll need to specifically allow remote connections as by default you can only connect on the localhost.  Use ssh to connect to your server then run any command locally

[adolfas]

http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.6.0-11.noarch.rpm

good luck!  

[hgomez]

Hi Everyone.

As far as I understood, MySQL is used internally for some purposes.

I would like to know how to access that database:

• Database Name
• Username
• Password
• Port to access it remotely (Standard 3306 ?)

Many thanks for your support.

Gil

Hi my friend, maybe you are on the rightway, but here is my experience:
in order to access mysql remotly you must rebuild /etc/my.cnf,
1.-
mkdir -p /etc/e-smith/templates-custom/etc/my.cnf
2.-
cp /etc/e-smith/templates/etc/my.cnf/* /etc/e-smith/templates-custom/etc/my.cnf
3.-
cd /etc/e-smith/templates-custom/etc/my.cnf
4.-
pico 005mysqld
add this line:
set-variable=thread_stack=256k
under [mysqld] line and Save.
5.-
/sbin/e-smith/expand-template /etc/my.cnf
6.-
cd /etc/rc.d/init.d
7.-
 ./mysqld stop
 ./mysqld start
8.-
write mysql and press intro
9.-
GRANT ALL ON *.* to jdoe IDENTIFIED BY 'johndoe';
10.-
now from every where you can access to mysql:
from windows: mysql -hYourSmithIP -ujdoe -pjohndoe

that is all, hope it help you.

[hgomez]

Hi Everyone.

As far as I understood, MySQL is used internally for some purposes.

I would like to know how to access that database:

• Database Name
• Username
• Password
• Port to access it remotely (Standard 3306 ?)

Many thanks for your support.

Gil

AHHH, when you get inside mysql server, you have this very simple commands:
show databases;
show tables;
use "Databasename";
select * from tables;

Bye.