Thanx I muddle thru it from here.
Have a good weekend.
  ----- Original Message ----- 
  From: Kjell Midtseter 
  To: LW Ellis 
  Sent: Saturday, June 19, 2004 12:52 AM
  Subject: Re: mysql install problem Continued

  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)

  insert into user 

  insert into user 
(host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv) values 

  insert into user (host,user,password,Select_priv) values 

  (You may want to select different database and user names)

  Databases and their users:

  insert into db 
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 

  insert into db (host,db,user,Select_priv) values 

  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:
  $_db = "db_one";
  mysql_connect($host, $user, $password);
  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.
  > 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

[EMAIL PROTECTED] mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to