Sara Woglom wrote:
Thanks Shawn!!
You should be thanking Mladen Adamovic for pointing you to:
http://dev.mysql.com/doc/mysql/en/grant.html
This page holds your answer. From the error message you got
Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to
this MySQL
Graham Cossey wrote:
Sorry, YMMV? What does that mean?
Is there a reference somewhere for all these acronyms?
Yes it's called Google.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday 22 July 2004 09:06 am, Jernej Koprivec wrote:
My first contact with MySQL.
When I try to login with the following two lines, I get an error code 1045
mysql -h localhost -u jk -p ENTER
PASSWORD: password
ERROR 1045: Access denied for user: [EMAIL PROTECTED] using password: YES
On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote:
shouldn't I be able to issue commands at the shell it goes and does it
thing and give back output? or does this mean I have a passwd already set
and it's secured?
On Thursday 24 June 2004 10:20 am, Dirk Bremer \(NISC\) wrote:
1. Is there a way to configure the server to just support MyISAM databases,
i.e. disabling the support for InnoDB? My though is that this would prevent
the same error from happening again.
Put skip-innodb in your my.conf
2. I
On Wednesday 23 June 2004 03:32 pm, tommie ramirez.andujar wrote:
Dear colleagues..
I am new to mysql and I am trying to do the following, to create a php file
that may contain some kind of form or survey and the data entered may be
added to a database. Here's the code of the html form
On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote:
I'm trying only to update one table from a backup. I have the sql file
stripped down to just the INSERT commands. I have emptied the table from
phpMyadmin to start.
How do I load this sql file so it runs all of the
On Friday 09 April 2004 11:40 am, Mark Susol | Ultimate Creative Media wrote:
On Friday 09 April 2004 11:29 am, you wrote:
I'm not getting an error..I'm getting inserts that are NOT in the file
I'm directing it to dump. Maybe I don't understand the dump function and
how it works with a sql
On Friday 09 April 2004 12:26 pm, Mark Susol | Ultimate Creative Media wrote:
Ok now I want to dump tables with names starting with phpads so I can
move them to another db. How is the mysqldump command run then?
And when I go to move them to the new db, I do use the mysqldump command
since I
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
You can set it as an alias using AS .
Respectfully,
Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typing
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
You can set it as an alias using AS .
Respectfully,
Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typing
Isn't there a way to prefix (or postfix) a tables column names in the results
of a select. For example I have a table named from_address. This table has
the column names line1,line2,line3,line4,line5. When I do a select query on
from_address I want all columns to return as from_line1,
On Thursday 22 January 2004 02:19 pm, David Blomstrom wrote:
I'm using a preconfigured package that includes PHPMyAdmin, which seems to
be a pretty good program. However, I just read that similar programs are
available, including MySQL Control Center, EMS MySQL Manager, urSAL,
PremiumSoft
I'm having sporadic myisam table corruption. This table is constantly being
added to, updated, and deleted from. PHPMyAdmin reports that The table is in
use when I try to access this table after corruption. After I perform this
step in the correct directory everything goes back to normal.
On Thursday 04 December 2003 03:42 pm, Stéphane Bischoff wrote:
Hi,
w do I know what my MySQL server IP is ??
thanks
How about ifconfig?
James Hicks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
went very fast!
James Hicks
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 7:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Slow batch load after 500MB
James E Hicks III [EMAIL PROTECTED] wrote:
I have encountered an interesting problem using
the mysql_statements.SQL into smaller files and
consecutively loaded these files, the load only took 5 minutes top. Any ideas
what I can do to get these large files to load without breaking them down? Is
there a server config value I missed?
James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757
I'd use MySQL, Apache, and UDMSEARCH. It provides the web interface for
the google search engine (Apache and UDMSearch), while connecting to
MySQL. If you want, the re-indexing can occur using a cron, and then by
making apache serve the documents from the root and doing the fancy
=pword DB_2update /fullpathto/thefile.SQL
mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), w
hen using table: thefile
For the filter.
sql, query
James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757-928-9000 ext 435
[EMAIL PROTECTED]
--
MySQL
Please ignore this this problem as I found the answer. For those inquring minds,
I added a -L to the mysqlimport command and we are all happy now.
James
-Original Message-
From: James E Hicks III [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 2:48 PM
To: Mysql
Subject
to
help!
James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757-928-9000 ext 435
[EMAIL PROTECTED]
For the filter (mysql MySQL SQL table row insert select delete)
-
Before posting, please check:
http
Is this query legal?
select distinct purchase_orders.header.vendor_number as number,
vendor_master.address.sequence_name as name from purchase_orders.header,
vendor_master.address where purchase_orders.header.branch = 10
With these DB's
# Database : `purchase_orders`
#
I've been using enum (Y,N).
James
-Original Message-
From: Vernon A Webb [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 10:58 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Checkbox table field
Alright then!
database,sql,query,table
Which field type do I use for a simply
23 matches
Mail list logo