Rick,
I will be glad to join you
Nestor :-)
-Original Message-
From: Rick Schulze [EMAIL PROTECTED]
Sent: Sep 8, 2005 1:21 PM
To: mysql@lists.mysql.com
Subject: San Diego mySQL usergroup
I would like to form a San Diego mySQL user group, I notice we don't
have one down here that I can
Can you also sent it to me.
Thanks!
Nesto r:-)
-Original Message-
From: J. David Boyd [EMAIL PROTECTED]
Sent: Aug 2, 2005 8:20 AM
To: mysql@lists.mysql.com
Subject: Re: Database equivalent to NorthWind for M$ SQL
Peter Brawley [EMAIL PROTECTED] writes:
Scott,
Is there any
Any report tools that can be use with Mysql that you guys can recommend?
Any free mysql report generators?
Thanks,
Nestor :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ezequiel,
Tambien hay una lista de mysql en Espagnol.
:-)
-Original Message-
From: Johan H��k [EMAIL PROTECTED]
Sent: May 11, 2005 4:35 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: just hi
Hi Ezequiel,
see:
http://dev.mysql.com/doc/
/Johan
Ezequiel Rodriguez wrote:
TO back up the databases in Mysql, isn't there a way where you can just copy
somefiles
to another directory and in essence you have a backup? I thought I read this
somewhere
No I can do a dump, but I was wondering if I can just copy some lies or a
directory.
Thanks,
Néstor Alberto Flórez
Hello world,
I am passing a a string Joe's car as part of the SQL query to be inserted
to a String field.
$field=Joe's car;
$query=insert into mytable values('$field');
Do you generally change the quote to a double quote before inserting
or what is the recomended way, because otherwise the
OS is W2K.
-Original Message-
From: nestor(earth) [EMAIL PROTECTED]
Sent: Sep 15, 2004 8:04 AM
To:
Cc: [EMAIL PROTECTED]
Subject: Mysql and PHP
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as
What command should I use to find out a table's constraints?
Thanks,
:-)
Néstor Alberto Flórez Torres
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] 3/22/2004 2:06:55 AM
Nestor Florez [EMAIL PROTECTED] wrote:
I have a php web application that has an admin page for inserting course =
records and one for selecting course records=20
and a client page for selecting course record. =20
In the admin side I insert records
People,
I have a php web application that has an admin page for inserting course records and
one for selecting course records
and a client page for selecting course record.
In the admin side I insert records with an insert into Course_Eng and I select
records witha select * from Course_Eng
Armin,
1)When you say that the records are duplicate, do you mean the record number(first
field) or or do you mean the entire record is a duplicate?
2)Now to load a file made out of comma separated fields into a table that was created
in the same field
format, here are 2 ways:
a)mysql USE
I have a mysql db where via a web page I access a database
I have set the permissions to
grant select, insert, update, delete on test.* to [EMAIL PROTECTED]
identified by 'nestor';
flush privileges;
The database has 3 tables. I can select via PHP code all the tables,
but when I try to insert
or
I forgot to mentioned that this same code works on the same database on
my W2K
but I am having problems on my Mac OS X (Darwin). I sqldump the
database from my W2K
to my Mac Os X.
Nestor :-)
Nestor A. Florez
Nestor Florez 11/13/2003 10:17:37 AM
I have a mysql db where via a web page I
X.
Nestor :-)
Nestor A. Florez
Nestor Florez 11/13/2003 10:17:37 AM
I have a mysql db where via a web page I access a database
I have set the permissions to
grant select, insert, update, delete on test.* to [EMAIL PROTECTED]
identified by 'nestor';
flush privileges;
The database has 3
I just realized that if I login to mysql as the user I can insert
records.
It must be somehting with my code
I will try the trace_on
It is just amazing that the same code works in my W2K machine
and when I ftp it to the Mac OS X only adding to th eschools fails.
Thanks,
Nestor :-)
Nestor A.
OK guys this is beyond me.
I just found out that I can NOT insert into my SCHOOL table
when I login into mysql as user nestor on my Mac OS X.
The table is autoincremented. how do I find out what is the next
number to be incremented?
Nestor :-)
Nestor A. Florez
Nestor Florez [EMAIL
be okay.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant permissions problems - help
.
The one with connect from anywhere is only allowed to modify the test
database. Fix your privileges and you should be okay.
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Grant
Thanks for the help to ALL
I got it to work.
I do not know how but I think that they might have been hidden
characters in the program doing insert
in the actuall insert statements. I retyped the insert code in the
program and things started to
work. Probably when I ftp the code somethin
I have not work with it but postgres is supposed to work great in
/BSD/Linux/Unix/solaris environment
Which platform are you using?
:-)
Nestor A. Florez
Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will
in /etc. Have
you run mysql_install_db yet?
- Gabriel
On Wednesday, November 5, 2003, at 05:57 PM, Nestor Florez wrote:
Hi guys,
I just was given the OK to play with a new server running
Mac OS X (Panther)
When I give the command (it is recommended to use mysqld_safe instead
of mysqld in some
, Nestor Florez wrote:
Hi guys,
I just was given the OK to play with a new server running
Mac OS X (Panther)
When I give the command (it is recommended to use mysqld_safe instead
of mysqld in some website)
*---
# /usr/bin/mysqld_safe
Egor,
Where is the datadir locate?
:-)
Nestor A. Florez
Egor Egorov [EMAIL PROTECTED] 11/6/2003 7:40:28 AM
Nestor Florez [EMAIL PROTECTED] wrote:
I tried running mysql_install_db and I get:
*---
# /usr/bin/mysql_install_db --force
Preparing db table
Preparing host
Thanks to all the help...I got it working!!!
Basically, as recommended, I created a my.cnf
I also chown my /var/mysql directory to user 'mysql'
and I am cooking now
Thanks again!!
Nestor :-)
Nestor A. Florez
--
MySQL General Mailing List
For list archives:
Hi guys,
I just was given the OK to play with a new server running
Mac OS X (Panther)
When I give the command (it is recommended to use mysqld_safe instead of mysqld in
some website)
*---
# /usr/bin/mysqld_safe
Starting mysqld daemon
Help,
Guys I have done this before but it is not working for me when I try to
do some
inserts via a file from the command line
c:\mysql mydb myfile.sql
ERROR 1044: Access denied for user: '@localhost' to database 'mydb'
I am logged in as administrator on my W2K and I have granted ALL
privileges
Did not workd, I get an error
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
I can log in as -u administrator when I use the -p option. I need to
make it work
from command line because I am planning to put this command in
a script to make it automatic to insert
Victoria Reznichenko [EMAIL PROTECTED] 10/15/2003
12:28:24 PM
Nestor Florez [EMAIL PROTECTED] wrote:
Help,
Guys I have done this before but it is not working for me when I try
to
do some
inserts via a file from the command line
c:\mysql mydb myfile.sql
ERROR 1044: Access denied for user
Interesting!
After reading about gator via this email I ran
ad-aware on my laptop and it found gator.
Could it be that one of these emails had it in it?
No more gator on my machine
C U later gator :-)
---Original Message---
From: _Chris McKeever_ [EMAIL PROTECTED]
Sent: 07/11/03
:-(
---Original Message---
From: Nils Valentin [EMAIL PROTECTED]
Sent: 07/11/03 06:34 PM
To: Nestor Florez [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: What's up with this GATOR crap?
Hi Nestor,
excuse me for my words, but what you write is crap. MySQL does definitely
NOT
include
am glad I read about it and I was just asking.
No biggy is out of my life.
Happy weekend to all :-)
---Original Message---
From: Ed Leafe [EMAIL PROTECTED]
Sent: 07/11/03 06:24 PM
To: Nestor Florez [EMAIL PROTECTED]
Subject: Re: What's up with this GATOR crap?
On Friday, July 11, 2003
I do not understand why people have to get hard on other people just because they ask
a question. If you do not a helpful thing to say well do not reply. The reason why
people ask is because there are looking for shortcuts that are known by those who have
been around and it is great because
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd);
And I ge the error:
Warning: Can't connect to MySQL server on
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd);
And I ge the error:
Warning: Can't connect to MySQL server on '10.1.1.3'
I messed up in the ip addressing sorry!
--
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd);
And I ge the error:
OK now I am getting this error:
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
/usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36
Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in
:-)
-Original Message-
From: Kevin Tsay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 11:53 AM
To: Nestor Florez
Cc: [EMAIL PROTECTED]
Subject: RE: Help on SQLyog
Nestor:
I've set the password for root and granted privileges to it.
see below:
mysql select * from user where
Is this an error in Mysql?
I do the follwing command from a shell
grant insert on mydb.* to username@localhost identified by user
'pwd';
When I check the permissions the insert_priv field on user table of mysql db
is set to 'N'.
Why is that? I can change the privileges by giving an
I have a db and a user with a pwd is allowed to access it.
If my user and pwd is incorrect my php scripts can not
access the db, which is what I expect.
I colleague of mine just went into Mysql db using OBDC connection
using microsoft Data source tool(I do not know much about microsoft)
and he
Sounds like you have a script an generally you run mysql script.sql
and the database and tables get created.
Make sure that the script creates your database and tables.
Nestor :-)
-Original Message-
From: lin ad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 5:56 PM
To:
IT is working as of yesterday.
The problem was that I was granting select, insert, update privileges to the
webuser and the change would not appear in the user table of the mysql
database.
Learn a new one yesterday. I try changing the privileges using the GRANT on
an existing user and they do
41 matches
Mail list logo