From owner-freebsd-questions@FreeBSD.ORG Sat Jun 19 06:52:45 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EB40A16A4CE for ; Sat, 19 Jun 2004 06:52:45 +0000 (GMT) Received: from mail.broadpark.no (mail.broadpark.no [217.13.4.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8536E43D45 for ; Sat, 19 Jun 2004 06:52:45 +0000 (GMT) (envelope-from junkmail@sensewave.com) Received: from tove (la3sg.net [217.13.29.172]) by mail.broadpark.no (Postfix) with ESMTP id 7381944D7; Sat, 19 Jun 2004 08:53:06 +0200 (MEST) From: "Kjell Midtseter" To: "LW Ellis" Date: Sat, 19 Jun 2004 08:52:43 +0200 MIME-Version: 1.0 Message-ID: <40D3FEDB.18460.6334A2@localhost> Priority: normal In-reply-to: <003101c455c6$680a7d60$0200a8c0@LLAPTOP> X-mailer: Pegasus Mail for Windows (v4.12a) Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7BIT Content-Description: Mail message body X-Content-Filtered-By: Mailman/MimeDel 2.1.1 cc: freebsd-questions@FreeBSD.org Subject: Re: mysql install problem Continued X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 19 Jun 2004 06:52:46 -0000 On 19 Jun 2004 at 0:26, LW Ellis wrote: > OK force didn't work, but I renamed hostname to localhost, > until the install was done. > When I rebooted it showed mysql started. First you have to let the SQL server know what databases and users you want to use: 1) Set password for root user after initial load # mysqladmin -u root password 'verysecret' 2) During subsequent user updates or adding new DataBase info: # mysql -u root -p mysql Enter password: (enter "verysecret" or whatever you entered in step 1) Users: insert into user (host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) values ('localhost','us_allprivileges',password('verysecret'),'Y','Y','Y','Y','Y','Y'); insert into user (host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv) values ('localhost','us_readandwrite',password('verysecret'),'Y','Y','Y','Y'); insert into user (host,user,password,Select_priv) values ('localhost','us_readonly',password('verysecret'),'Y'); (You may want to select different database and user names) Databases and their users: insert into db (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) values ('localhost','db_one','us_allprivileges','Y','Y','Y','Y','Y','Y'); insert into db (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv) values ('localhost','db_one','us_readandwrite','Y','Y','Y','Y'); insert into db (host,db,user,Select_priv) values ('localhost','db_one','us_readonly','Y'); 3) Create new data base # mysqladmin -u root -p create db25872a Enter password: SQL server must be restarted for changes to take effect: mysqladmin -p -u root reload > Now please can you tell me how to access it. > In Dreamweaver, I need a SQL (server) generally an IP address. Start with a index.html page containing a "hello Leon" When this is working try the same in a index.php page. This working you are ready to access your SQL server through the MySQL PHP API to Apache. You connect to your database using the following piece of coding: Now you are ready to issue your select, update, insert, etc. statements in your PHP code. A bit of Googling will produce several introductions to PHP/MySQL coding. > I have named running on my machine, do I need to configure > this to point to mysql server. No > I downloaded mysql handbook, which should handle that end. > (I know sql language, but I am an ASP kind of guy) > Thanx for all your help. > > Leon