Arfon: /etc/rc.d/rc.mysql start --> /etc/rc.d/rc.mysqld start AND ADDED: mysql> use mysql

2012-08-06T15:30:58Z

/etc/rc.d/rc.mysql start --> /etc/rc.d/rc.mysqld start AND ADDED: mysql> use mysql

← Older revision		Revision as of 15:30, 6 August 2012
Line 27:		Line 27:
	You're now finished and should not see the typical MySQL errors at the login prompt.		You're now finished and should not see the typical MySQL errors at the login prompt.

	/etc/rc.d/rc.~~mysql~~ start		/etc/rc.d/rc.mysqld start

	Now you should set a password for MySQL's root password:		Now you should set a password for MySQL's root password:
Line 40:		Line 40:
	For security reasons you should delete an empy user for localhost server		For security reasons you should delete an empy user for localhost server
	<pre>		<pre>
			mysql> use mysql
	mysql> SELECT user, host FROM user;		mysql> SELECT user, host FROM user;
	mysql> DELETE FROM user WHERE host='localhost' AND user='';		mysql> DELETE FROM user WHERE host='localhost' AND user='';

Arfon: chmod 755 /etc/rc.d/rc.mysql --> chmod 755 /etc/rc.d/rc.mysqld

2012-08-06T15:22:36Z

chmod 755 /etc/rc.d/rc.mysql --> chmod 755 /etc/rc.d/rc.mysqld

← Older revision		Revision as of 15:22, 6 August 2012
Line 22:		Line 22:
	<pre>		<pre>
	chown -R mysql.mysql /var/lib/mysql		chown -R mysql.mysql /var/lib/mysql
	chmod 755 /etc/rc.d/rc.~~mysql~~		chmod 755 /etc/rc.d/rc.mysqld
	</pre>		</pre>

Erik: Copy from old

2009-06-02T03:35:46Z

Copy from old

New page

[[Category:Tutorials]]
''Have you just installed Slackware and now see a MySQL error at the login prompt?''

This is a VERY quick HowTo and should take maybe 30 seconds to complete at its slowest. The reason I decided to do a write-up is because of the sheer number of people asking how to fix it.

== Option 1 ==
In a shell or xterm, type (you have to be logged in as superuser to use the mysql login):

su mysql

This logs you into the 'mysql' user account.

Next, run:

mysql_install_db

This will create the needed databases and set their permissions properly.

if your not logon as mysql user (root)

Don't forget to chown folder /var/lib/mysql
<pre>
chown -R mysql.mysql /var/lib/mysql
chmod 755 /etc/rc.d/rc.mysql
</pre>

You're now finished and should not see the typical MySQL errors at the login prompt.

/etc/rc.d/rc.mysql start

Now you should set a password for MySQL's root password:

mysqladmin -u root password 'new-password-here'

You can connect to your MySQL server with:
mysql -u root -p

For security reasons you should delete an empy user for localhost server
<pre>
mysql> SELECT user, host FROM user;
mysql> DELETE FROM user WHERE host='localhost' AND user='';
</pre>
*''This tutorial is currently linked at ''
* ''http://www.unixfool.com/mysql-slack.shtml''

== Option 2 ==
1. log in as root and install the mysql package

2. <code>killall -9 mysqld mysqld_safe</code> to kill any running MySQL processes.

3. copy one of the my-size.cnf files in /etc to my.cnf (picking an apporpriate size): 
::<code>cp /etc/my-medium.cnf /etc/my.cnf</code>

4. Install the MySQL database-

::'''Slackware 12.1''' (and later):
::::<code>mysql_install_db --user=mysql</code>

::'''Slackware 12.0''' (and before):
::::<code>su mysql</code>
::::<code>mysql_install_db</code>
:::: <code>exit</code> (to get out of the mysql login and back to root).

5. <code>mysqld_safe --skip-grant-tables &</code>

6. <code>mysql -u root mysql</code>

7. <code>UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';</code>

8. <code>FLUSH PRIVILEGES;</code>

9. <code>exit</code>

10. <code>killall -9 mysqld mysqld_safe</code>

11. <code>mysqld_safe &</code>

to check the new password, (as root) type: 
::<code>mysqladmin -u root -p status</code> 
:::::...and enter the new password.

== Option 3 ==

I'm starting from a [http://www.slackwiki.org/Minimal_System very basic install].

The only additional package needed is '''mysql''' in the '''AP''' group.

<pre>
# installpkg mysql-5.0.37-i486-1.tgz
# su mysql
$ mysql_install_db
Installing all prepared tables
Fill help tables
...
$ exit
# chmod 755 /etc/rc.d/rc.mysqld
# /etc/rc.d/rc.mysqld start
Starting mysqld daemon with databases from /var/lib/mysql
</pre>

MySQL is now installed, but there are no passwords defined yet.

<pre>
# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
</pre>

We can now set passwords from within the MySQL console. I know this can be achieved with '''mysqladmin''', but then, several ways lead to Rome. It's a simple matter of habit.

<pre>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.01 sec)

mysql> use mysql;
Database changed

mysql> select user, host, password from user where user = 'root';
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
| root | slacktest | |
+------+-----------+----------+
2 rows in set (0.00 sec)
</pre>

As you can see, there are two 'root' users here (and none of them is our system's root user, don't forget): root@localhost... and root@slacktest. We have to set a password for both of them. In theory, these can be different, but why make things more complicated than they already are? ;o)

<pre>
mysql> set password for root@localhost = password('yatahongaga');
Query OK, 0 rows affected (0.00 sec)
</pre>

Let's repeat our query above to see the actual changes:

<pre>
mysql> select user, host, password from user where user = 'root';
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *71CDE2704222D8D5A7608C92AF78C53F78DA5EBA |
| root | slacktest | |
+------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)
</pre>

You can see that root@localhost's password is displayed as a shadow password. Now let's set the password for root@slacktest (replace ''slacktest'' by your machine's hostname):

<pre>
mysql> set password for root@slacktest = password('yatahongaga');
Query OK, 0 rows affected (0.00 sec)
</pre>

What do we have now?

<pre>
mysql> select user, host, password from user where user = 'root';
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *71CDE2704222D8D5A7608C92AF78C53F78DA5EBA |
| root | slacktest | *71CDE2704222D8D5A7608C92AF78C53F78DA5EBA |
+------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)
</pre>

Now we have some (very) basic security, we can leave the MySQL monitor.

<pre>
mysql> quit;
Bye
</pre>

To connect to our MySQL database as MySQL's root user (who, remember, is ''not'' the system's root), we can do the following:

<pre>
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.37 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
</pre>

If we have to do this often, we can create a /root/.my.cnf file and edit it as follows:

<pre>
[mysql]
user = root
password = yatahongaga
</pre>

Just to be on the safe side:

<pre>
# chmod 0600 /root/.my.cnf
</pre>

From now on, you can connect directly to the MySQL monitor, without having to type your password every time.

MySQL Configuration - Revision history

Arfon: /etc/rc.d/rc.mysql start --> /etc/rc.d/rc.mysqld start AND ADDED: mysql> use mysql

Arfon: chmod 755 /etc/rc.d/rc.mysql --> chmod 755 /etc/rc.d/rc.mysqld

Erik: Copy from old