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]
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]
