Re: mysql install problem Continued
Kjell,
I tried setting up the following line (from you)
INSERT INTO
VALUES
('localhost','username',password('very_secret'),
'Y','Y',etc...);
I have used anywhere from 6 to 14 'Y' (from the MySQL handbook)
I get the following error
Column count doesn't match value count at row 1
Where did I go wrong.
I have been playing around with a sample DB until now...
Thanx in advance.
Leon
Users:
insert into user
(host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_p
riv,Drop_priv)
values
('localhost','us_allprivileges',password('verysecret'),'Y','Y','Y','Y','Y','
Y');
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql install problem Continued
One thing you can do to get around large INSERT collumn count matching is
use this syntax:
INSERT INTO user SET Host='localhost', User='username',
Password=password('very_secret'), Select_priv='Y', Insert_priv='Y',
etc.etc.etc.
You will have to identify your table first, use:
desc user
Maybe this will help.
R.
On Sat, 26 Jun 2004, LW Ellis wrote:
Kjell,
I tried setting up the following line (from you)
INSERT INTO
VALUES
('localhost','username',password('very_secret'),
'Y','Y',etc...);
I have used anywhere from 6 to 14 'Y' (from the MySQL handbook)
I get the following error
Column count doesn't match value count at row 1
Where did I go wrong.
I have been playing around with a sample DB until now...
Thanx in advance.
Leon
Users:
insert into user
(host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_p
riv,Drop_priv)
values
('localhost','us_allprivileges',password('verysecret'),'Y','Y','Y','Y','Y','
Y');
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql install problem Continued
OK force didn't work, but I renamed hostname to localhost, until the install was done. When I rebooted it showed mysql started. Now please can you tell me how to access it. In Dreamweaver, I need a SQL (server) generally an IP address. 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 http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Solved mysql install problem
Thanx I muddle thru it from here.
Have a good weekend.
Leon
- Original Message -
From: Kjell Midtseter
To: LW Ellis
Cc: [EMAIL PROTECTED]
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,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
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
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,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
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql install problem
I get the following error when I try to install mysql40-server from the ports. Neither host '192' or 'localhost' could be resolved with usr/local/bin/resolveip I went thru something similar when I was configuring apache. I had to resolve it by setting the host name to the name assigned by my router (also a dhcp server) It says I can resolve this later by installing with the --force option. I looked in the man pages, and the handbook. Could someone please tell me how to invoke the force option. I used make install command. Later, Leon A fanatic is one who can't change his mind and won't change the subject. Sir Winston Churchill ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql install problem
On 18 Jun 2004 at 22:08, LW Ellis wrote: I get the following error when I try to install mysql40-server from the ports. Neither host '192' or 'localhost' could be resolved with usr/local/bin/resolveip I went thru something similar when I was configuring apache. I had to resolve it by setting the host name to the name assigned by my router (also a dhcp server) It says I can resolve this later by installing with the --force option. I looked in the man pages, and the handbook. Could someone please tell me how to invoke the force option. I used make install command. make -D FORCE_INSTALL ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql install problem
thanks, I couldn't find it in the man pages. Been reading, should I put my mysql server in a 'virtual host' or is it seperate from my apache server - Original Message - From: Kjell Midtseter [EMAIL PROTECTED] To: LW Ellis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 18, 2004 11:15 PM Subject: Re: mysql install problem On 18 Jun 2004 at 22:08, LW Ellis wrote: I get the following error when I try to install mysql40-server from the ports. Neither host '192' or 'localhost' could be resolved with usr/local/bin/resolveip I went thru something similar when I was configuring apache. I had to resolve it by setting the host name to the name assigned by my router (also a dhcp server) It says I can resolve this later by installing with the --force option. I looked in the man pages, and the handbook. Could someone please tell me how to invoke the force option. I used make install command. make -D FORCE_INSTALL ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql install problem
On 18 Jun 2004 at 23:20, LW Ellis wrote: thanks, I couldn't find it in the man pages. Been reading, should I put my mysql server in a 'virtual host' or is it seperate from my apache server No connection to apache and virtual host Just install it and the startup scripts will be installed for you. The next time you reboot you will see a startup message saying that is has been started. - Original Message - From: Kjell Midtseter [EMAIL PROTECTED] To: LW Ellis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 18, 2004 11:15 PM Subject: Re: mysql install problem On 18 Jun 2004 at 22:08, LW Ellis wrote: I get the following error when I try to install mysql40-server from the ports. Neither host '192' or 'localhost' could be resolved with usr/local/bin/resolveip I went thru something similar when I was configuring apache. I had to resolve it by setting the host name to the name assigned by my router (also a dhcp server) It says I can resolve this later by installing with the --force option. I looked in the man pages, and the handbook. Could someone please tell me how to invoke the force option. I used make install command. make -D FORCE_INSTALL ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
