Date: Sat, 19 Jun 2004 01:10:45 -0600 From: "LW Ellis" <lwellis@mindspring.com> To: "Kjell Midtseter" <junkmail@sensewave.com>, <freebsd-questions@freebsd.org> Subject: Solved mysql install problem Message-ID: <005501c455cc$8a7ddc10$0200a8c0@LLAPTOP> References: <40D3FEDB.18460.6334A2@localhost>
next in thread | previous in thread | raw e-mail | index | archive | help
Thanx I muddle thru it from here. Have a good weekend. Leon ----- Original Message -----=20 From: Kjell Midtseter=20 To: LW Ellis=20 Cc: freebsd-questions@FreeBSD.org=20 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) Users: insert into user = (host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv,Creat= e_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:=20 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"=20 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=3D"localhost"; $_db =3D "db_one"; $user=3D"us_readandwrite"; $password=3D"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. >=20 > Leon
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?005501c455cc$8a7ddc10$0200a8c0>