Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: simpleone on February 15, 2002, 02:23:01 AM

Title: mysql
Post by: simpleone on February 15, 2002, 02:23:01 AM

Hi all,

I know this has been talked about a number of times, but i need some help. I am trying to creat a new database and it is asking for the mysql password. This password is in the .my.cnf file which i have opened has the following

[client]
password=g59fn5Migun43+Hw6AURWaNc8lHCQSa0qeBjzskyIlMBtqD8V58qsWHjItlISiplPxEpl5Fv94Xu

Is this the password or do i need to convert it to something else as i have entered this one and it didn't work ?

Title: Re: mysql
Post by: Garret on February 15, 2002, 06:13:46 AM

It is the password

Title: Re: mysql
Post by: simpleone on February 15, 2002, 08:05:51 AM

how do i create a new database with this

Title: Re: mysql
Post by: simpleone on February 15, 2002, 08:13:14 AM

I am trying to do this can anyone help.

Installation is relatively straightforward.

First unzip or untar the package in your own directory. This will yield the following files:


-rwxr-xr-x    1 1604 Aug 31 13:43 adsl.sql*
-rwxr-xr-x    1 4815 Aug 31 13:45 adsllog.php*
-rw-r--r--    1 9975 Aug 31 13:42 adslstats.php
-rw-r--r--    1 1232 Aug 31 13:43 adslstats.sql


Now ensure that you have created a user with a password with MySQL who is allowed to create databases. See the MySQL documentation if you are not sure how to create such a user.

Create the database using the command (changing username to your name)

mysqladmin --user=username -p adsl

You will be prompted for the password. Then create the tables in the database using the command:

mysql --user=username -p adsl
Now the database is all set-up. Now edit the php scripts so that they contain the correct username and password at the top of these files.

Title: Re: mysql
Post by: Garret on February 15, 2002, 02:58:50 PM

or you can use myPHPadmin, it works very well and is able to plug right into an ibay. I load that us, and then with that change the root password to something managable. :-)

Title: Re: mysql
Post by: Beno on February 18, 2002, 08:00:40 AM

myPHPadmin


There is nothing better than this.  You wont beleive how easy it it to use and administer.

can find it at

http://php.resourceindex.com/Complete_Scripts/Database_Manipulation/SQL_Databases/

Title: Re: mysql
Post by: Ari on February 18, 2002, 07:39:25 PM

mysqladmin -u root create database_name

is the command prompt you need to create the database name.

Just make sure that you give the appropriate level of access to the user you created as per your adsl documentation

more info and complete documentation for MySQL can be found at:
http://www.mysql.com/documentation/index.html

Cheers!
Ari