I have installed MySQL Server, version which comes with Slackware 12.1, and I wanted to allow external machines connect to it. Slackware 12.1 has a default configuration to not allow such connections however I needed so in the start-up script /etc/rc.d/rc.mysql there is a option, given that constraint this function --skip-networking I have already commented such line to allow the connection from remote computers to this MySQL data base instance.

By other hand, after have enable remote connections, at the booting process in Slackware 12.1 I cannot reach the log-in prompt, I reach to see the line which says: starting mysql with /var/lib/mysql but until here, nothing more happens and the system, get "stuck", "freeze" not continue loading.

-1 Did I made something wrong to enable remote connections in MySQL that comes with this Slackware ? How must be do it ?

-2 How can I fix this issue?

Kind regards,

Near the top of rc.mysqld, there is information on how to initialize the server.

MySQL by default only sets up localhost connections. You need to add user accounts that specify the hostname or IP address in the mysql database. This isn't a Slackware specific issue but rather MySQL defaults.

Something like this would allow connections from a remote IP Address say if my MySQL server is using 192.168.100.50:

mysql> grant all privileges on *.* from 'user@192.168.100.100' identified by 'you-password';

Now go read the MySQL docs to learn more about user administration and locking it down. You don't want to open MySQL connections to everyone, that's a bad security idea..

My major concern is not the data base connection right, is that MySQL seems like not able to startup at the Slackware booting, thank you

I have everything as is required by the comments in this script
mysql_install_db was execute
user mysql and permissions on /var/lib/mysql/ directory

What happends if I try to run mysql_secure_installation with all my data base already created with data too ? Will I lost everything ? thank you

Not that I know of. The installation scripts with MySQL only create the default mysql database and test databases. If there are existing databases, I believe they leave them intact. But always back them up just in case.