Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: pippin on May 08, 2006, 03:08:22 PM

Title: mysql password
Post by: pippin on May 08, 2006, 03:08:22 PM
is it the same password as admin,root?

i am setting up a forum and cant get into the database with the password for admin,root

so the result is that i cant install unless i use /usr/bin/mysqladmin -u root password 123456789

But then i cant log in to my database and create a new  :cry:
Title: Re: mysql password
Post by: cactus on May 08, 2006, 04:18:33 PM
Quote from: "pippin"
is it the same password as admin,root?

i am setting up a forum and cant get into the database with the password for admin,root

so the result is that i cant install unless i use /usr/bin/mysqladmin -u root password 123456789

But then i cant log in to my database and create a new  :cry:

Never and I mean really never change your MySQL root password, this is used internally in the SME Server.

If you login at your server you can access the mysql client with the root account without a password, this account only works locally. With this account you can create a new account with the proper privileges to access your server (see the mysql manual for this).

If this user has to login from a remote machine you will have to change your mysql configuration to have it accept connections at a port as it is default configured to use a socket. I don't know to do this by heart, but it has been explained on the forums several times, please use the search funtion.
Title: mysql password
Post by: pippin on May 08, 2006, 05:51:12 PM
Well if i try to install a forum i do it locally :-D Or am i wrong ;-)
Title: mysql password
Post by: pfloor on May 08, 2006, 06:58:24 PM
Cactus is correct...NEVER mess with the root password.  It is 72 characters long and you don't need to know what it is or ever have to use it.

To install a forum, do the following:

Log into mysql. No password is required, just type mysql at the command line.
Create a NEW database for your forum.
Create a NEW user with appropriate permissions for access to the new database.

Use the new database and user you just created in your new forum during the forum setup.
Title: mysql password
Post by: pippin on May 08, 2006, 07:56:33 PM
How do you do that?
I am newbee on databases and mysql :-)
Title: mysql password
Post by: Boris on May 08, 2006, 08:46:21 PM
>>I am newbee on databases and mysql <<

Install phpmyadmin contrib for your SME (found here on this site). This would be great help for managing your MySQL.
Title: mysql password
Post by: cactus on May 08, 2006, 11:14:13 PM
Quote from: "pippin"
How do you do that?
I am newbee on databases and mysql :-)

[list=1]
Title: mysql password
Post by: pfloor on May 09, 2006, 01:31:52 AM
Quote from: "Boris"
>>I am newbee on databases and mysql <<

Install phpmyadmin contrib for your SME (found here on this site). This would be great help for managing your MySQL.


CAUTION!!! phpmyadmin gives you unrestricted root privileges to mysql and will allow you (and make it VERY EASY) to change the mysql root password.  MANY people (even experienced users) have done this either on purpose or by accident.

DO NOT CHANGE THE MYSQL ROOT PASSWORD!!!

phpmyadmin can be used to do things to your mysql databases that should not be done.  DON'T take this tool lightly.

It is an extremely powerful tool and may be very useful if you need to administer your databases all the time.  If you just want to create a database and user or 2, just do it manually as cactus indicates.
Title: mysql password
Post by: pippin on May 09, 2006, 07:23:24 AM
as i said i am newbee and havent the clue what to do to make a new user ;-)

Someone have to point me in the right direction and explain in details how to do it :-)
Title: mysql password
Post by: pfloor on May 09, 2006, 07:32:08 AM
Here is a how-to on how to install phpbb on sme5X.  It still applies to 7X.  

http://no.longer.valid/phpwiki/index.php/How%20to%20set%20up%20phpBB%202.0.0%20on%20SME%20Server%205.0%20or%205.1.2

An excerpt from the how-to on how to create a database and user

You're almost ready to configure phpBB.  If you don't have a current installation, you'll need to create a database and database user for phpBB before you proceed.  Note that you can (and should) change "phpbbpassword" below to some other password:

[root@test httpd.conf]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.36

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

mysql> CREATE DATABASE phpbb;
Query OK, 1 row affected (0.10 sec)

mysql> GRANT ALL PRIVILEGES ON phpbb.* TO phpbbadmin@localhost IDENTIFIED BY 'phpbbpassword';
Query OK, 0 rows affected (0.16 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.06 sec)

mysql> quit
Bye


There are many how-to's and documentation on this site.  The search box in the upper-left-hand corner is your friend.