Prev: Slack faq-o-matic
Next: Define character set in KDE or XFCE (Slack 13)
From: Robert Rappaport on 29 Apr 2010 19:10
I am using Slackware 12.2 with mysql-5.0.67 and am trying to develop a
LAMP application for my local network. When I start mysqld with
/usr/bin/mysqld_safe & or rc.mysqld start, I get the initial message and
a flashing cursor. The only way I can get a command prompt is by
hitting control c. From that point I have been able to create a data
base, a user account, and grant all privileges without incident.

I would like to start mysld at boot but want to get the hangup problem
solved first.

Can anyone suggest a solution?

Thanks

Bob
From: Henrik Carlqvist on 30 Apr 2010 01:54
Robert Rappaport <paperbag(a)cox.net> wrote:
> When I start mysqld with /usr/bin/mysqld_safe & or rc.mysqld start, I
> get the initial message and a flashing cursor. The only way I can get a
> command prompt is by hitting control c.

I have been using mysqld on Slackware 12.2 but have not seen that problem.
As far as I can remember the only things I did to set it up was to follow
the instructions in rc.mysqld, that is:

# Before you can run MySQL, you must have a database. To install an initial
# database, do this as root:
#
# su - mysql
# mysql_install_db

If your problem is that you forgot this step it seems as it can be fixed
later:

# Note that step one is becoming the mysql user. It's important to do this
# before making any changes to the database, or mysqld won't be able to write
# to it later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').

regards Henrik
--
The address in the header is only to prevent spam. My real address is:
hc3(at)poolhem.se Examples of addresses which go to spammers:
root(a)localhost postmaster(a)localhost

From: Robert Rappaport on 30 Apr 2010 19:24
Henrik Carlqvist wrote:
> I have been using mysqld on Slackware 12.2 but have not seen that problem.
> As far as I can remember the only things I did to set it up was to follow
> the instructions in rc.mysqld, that is:
>
> # Before you can run MySQL, you must have a database. To install an initial
> # database, do this as root:
> #
> # su - mysql
> # mysql_install_db

I used the this command as root:
mysql_install_db --user=mysql
>
> If your problem is that you forgot this step it seems as it can be fixed
> later:
>
> # Note that step one is becoming the mysql user. It's important to do this
> # before making any changes to the database, or mysqld won't be able to write
> # to it later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').
>
> regards Henrik

Since I havent used the new database I am going to delete everything and
start over as you suggest. Thanks,
Bob
From: ariarat on 1 May 2010 03:51

4 steps :

# su - mysql
# mysql_install_db
# chown -R mysql.mysql /var/lib/mysql
# /etc/rc.d/rc.mysqld start


From: Martin Schmitz on 1 May 2010 06:18
ariarat wrote:
> 4 steps :
>
> # su - mysql
> # mysql_install_db
> # chown -R mysql.mysql /var/lib/mysql
> # /etc/rc.d/rc.mysqld start

5th step:

# mysql_secure_installation

Martin

 | 
Pages: 1
Prev: Slack faq-o-matic
Next: Define character set in KDE or XFCE (Slack 13)