ll work if I add the fields 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 t
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 varc
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
hort hash. "
-
READ THIS:http://dev.mysql.com/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 th
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
> > > periodic
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
>
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
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 a
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 Tor
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 t
abase host: localhost
Database name: 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]
MAIL 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
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 M
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]
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]
> show tables;
+-+
| 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óre
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 for
work and returned me
the most records
My server is a Mac OS 10.2 and the Mysql version is "server version: 4.0.16"
Any ideas?
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]
USE 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 <[
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 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');
Q
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
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 F
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
+-+
| Grants for [EMAIL PROTECTED]
|
+-+
| GRANT USAGE ON *.* TO 'n
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 wher
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
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
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
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/
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, No
own...
031106 7:23:11 InnoDB: 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 >>
mplete
031105 13:09: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
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,
Nes
to insert 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 adminis
ydb.* to '%@'%' identified by 'pwd';
No luck here.
Any 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]
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?
>
go have a beer dude.
Nestor :-(
---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 y
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 06:
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 yo
ss denied for user: '[EMAIL PROTECTED]' (Using password: YES)
-
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 u
: YES) in /usr/local/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
on
line 36
Can't connect to MySQL server 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
r on '66.161.11.215' (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/ (th
server on '66.161.11.215' (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/
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
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,
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
ge the privileges by giving 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 th
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 F
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 A
54 matches
Mail list logo
