Scott,
I do not think that is how it works under revision 4.0.21.
Thanks,
Néstor :-)
On 7/5/06, Scott Haneda [EMAIL PROTECTED] wrote:
People,
I have the following table:
DROP TABLE IF EXISTS bid;
CREATE TABLE bid (
bid_id int(11) NOT NULL auto_increment,
bid_proj_name varchar(100)
that I am
importing via phpmyadmin
I guess I will just do it that way. When I am importing a file just
add the field names
that I am bringing in.
Thanks to all,
Néstor :-)
On 7/5/06, Chris [EMAIL PROTECTED] wrote:
Nestor wrote:
People,
I have the following table:
DROP TABLE IF EXISTS bid
People,
I have the following table:
DROP TABLE IF EXISTS bid;
CREATE TABLE bid (
bid_id int(11) NOT NULL auto_increment,
bid_proj_name varchar(100) NOT NULL default '',
bid_prop_name varchar(100) NOT NULL default '',
bid_amount varchar(20) NULL default '',
bid_sub_name varchar(100) NOT NULL
/doc/refman/5.0/en/password-hashing.html
Nestor :-)
On 3/21/06, Charles Gambrell [EMAIL PROTECTED] wrote:
I know this must be a simple issue and maybe I am asking it in the
wrong place, so if the latter is the case, please direct me to the
correct place.
I am getting my feet wet with MySQL
also I am ahving problems accessing the DB from phpmyadmin
I am running php 4.4.2
Client API version 3.23.49
mysql 5.0.18-nt
apache 2.0.55
Help?
Nestor :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it work on xp :-)
On 12/16/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Harrison Fisk [EMAIL PROTECTED] wrote on 12/16/2005 11:54:01 AM:
Hi,
On Dec 16, 2005, at 9:23 AM, C.R.Vegelin wrote:
I use various script files with queries to update a MySQL base
periodically.
These
I have used both and I prefer php/mysql
:-)
On 11/4/05, Peter Brawley [EMAIL PROTECTED] wrote:
Marc,
I've been using ASP for years but I have to work on a bigger project
involving many
users and data so of course, Access is not an option anymore. Since
it's a project requiring
thousand
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
: moodle
Database user: root
What should I check in Mysql?
All of this stuff work with mysql 3.?? and php 4.3.1
Thanks ,
Nestor :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ago.
Any ideas?
Thanks!
Nestor :-)
http://www.IneedWork.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
PROTECTED]
Sent: Wednesday, September 15, 2004 11:10 AM
To: nestor(earth)
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql and PHP
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
[EMAIL PROTECTED] wrote:
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have
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]
;
+-+
| Tables_in_ecrop |
+-+
| course_eng |
| course_esp |
+-+
I have it working by switching all my commands to access Course_Eng but I was
just wondering about this.
Thanks for your help :-)
Nestor :-)
Néstor A. Flórez
Victoria Reznichenko
I send this last week and no one commented.
Has anyone run into this simmilar problem?
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 10:28 AM
I have a php web application that has an admin page for inserting course
records and one
?
thanks,
Nestor :-)
Néstor A. Flórez
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
db1;
mysql LOAD DATA INFILE data.txt INTO TABLE db2.my_table;
b)C:\ mysql databasename filename
(You just got to make sure that the beginning of the file has the insert
statement in it )
GOdd Luck,
Nestor :-)
-Original Message-
From: Armin [EMAIL PROTECTED]
Sent: Jan 9
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
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
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'nestor
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
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
Victor,
I will fixed this, but I do not think this is th eproblem.
I have the same settings on both W2K and Mac OS X and it only fails on
the Mac
Also When I log in as nestor with a password on the Mac I can not
insert a record
from the ocmmand line. I can do this on my W2K database.
Thanks I
I actually took a look at the mysql.user table and user nestor has a
password in both entries to the table.
One entry is for localhost and the other is for '%';
I try inserting from the command line and I get:
mysql insert into School (school_desc) values ('Nestor');
Query OK, 1 row affected
gelse got added.
Thanks again,
Nestor :-)
Nestor A. Florez
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
: Shutdown completed
031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete
031106 07:23:11 mysqld ended
*--
Any other ideas?
Thanks,
:-)
Nestor A. Florez
Gabriel Ricard [EMAIL PROTECTED] 11/5/2003 4:33:07 PM
Are you using Panther client or server? my.cnf is usually
My OS X does not have my.cnf anywhere on the machine.
:-)
Nestor A. Florez
Gabriel Ricard [EMAIL PROTECTED] 11/5/2003 4:33:07 PM
Are you using Panther client or server? my.cnf is usually in /etc. Have
you run mysql_install_db yet?
- Gabriel
On Wednesday, November 5, 2003, at 05:57 PM
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: http://lists.mysql.com
:40 mysqld ended
*
I search for the my.cnf and I do not find it, but I know that Mac OS X puts
things in different places.
Any ideas?
Thanks :-)
Nestor A. Florez
--
MySQL General Mailing List
For list archives: http
ideas?
Thanks,
Nestor :-)
Nestor A. Florez
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
records.
Nestor :-)
Nestor A. Florez
Tobias Asplund [EMAIL PROTECTED] 10/15/2003 12:02:21 PM
c:\mysql mydb myfile.sql
ERROR 1044: Access denied for user: '@localhost' to database 'mydb'
try mysql -u administrator mydb myfile.sql
--
MySQL General Mailing List
For list archives: http
Believe it or not I tried
mysql -p administrator -p pwd mydb myfile.sql
and it would not worked, but when I got rid of the space it work
mysql -uadministrator -upwd mydb myfile.sql
I did not think that the spaces after the '-u' and the '-p' matter
Thanks,
Nestor :-)
Nestor A. Florez
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
Mysql.
Last time I ran ad-aware was about a 2 weeks ago and I did not have the gator then.
I am happy tha someone mentioned the gator and I removed it. There is no need for you
to star a friendship in such a rude manner. Read my email again!
It is Friday night, Nils go have a beer dude.
Nestor
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
)
-
Line 36 is my php connect statement
mysql_connect('10.1.1.2','mbn','pwd');
Do I need to put a client in the webserver(10.1.1.3) running Linux?
It there something I need to set up on the dbserver(10.1.1.2) running W2K?
Any ideas?
Thanks,
Nestor :-)
---
Outgoing mail is certified Virus
mymysql_connect function is at.
Any ideas?
Nestor :-)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
mymysql_connect function is at.
Any ideas?
Nestor :-)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
on '10.1.1.3' (111)
Line 36 is where mymysql_connect function is at.
Any ideas?
Nestor :-)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
/httpd/htdocs/mbn.com/confirmation.php on
line 36
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
I look at the db table of mysql and [EMAIL PROTECTED] has select and insert
permissions
on the table that I am trying to connect
Nestor
Check the db table in mysql database. See what that says
also, I notice the error was that kevin.smith.com not allowed
sould that be [EMAIL PROTECTED] not allowed?
Generally you will get kevin@localhost not allowed.
Grant priviledges to that user on that machine as [EMAIL PROTECTED]
Nestor
an update command.
Any ideas?,
Nestor :-)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
meaning there are only 2 entries in the user table of the Mysql db
one of them being root.
Any ideas?
Thanks,
Nestor :-)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
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
not change. I think this might be an error. I
try this on several machines and the solution is to performa a query on the
privileges on the user table of the mysql database.
Nestor :-)
On Fri, 20 Sep 2002 09:48:09 -0700 Clayburn W. Juniel, III [EMAIL PROTECTED]
wrote:
On Friday, September 20
I have written previous websites where I used perl or PHP
to access a Mysql DB wen bith the webserver and the Mysql
db are on the same server.
My questions is how different is it to access or connect
to the Mysql database when the database is on a separate
server(machine)?
Thanks,
Nestor
54 matches
Mail list logo