Date: Sat, 19 Jun 2004 08:52:43 +0200 From: "Kjell Midtseter" <junkmail@sensewave.com> To: "LW Ellis" <lwellis@mindspring.com> Cc: freebsd-questions@FreeBSD.org Subject: Re: mysql install problem Continued Message-ID: <40D3FEDB.18460.6334A2@localhost> In-Reply-To: <003101c455c6$680a7d60$0200a8c0@LLAPTOP>
next in thread | previous in thread | raw e-mail | index | archive | help
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:
<?
$host="localhost";
$_db = "db_one";
$user="us_readandwrite";
$password="verysecret";
mysql_connect($host, $user, $password);
mysql_select_db($_db);
?>
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?40D3FEDB.18460.6334A2>