Original Subject: Re: connecting without a password
Thanks for send us email. We've delivered your email to
@cathaybk.com.tw! Reminding!! Our Email domain is changed as
@cathaybk.com.tw
What does this mean.
Best wishes,
-Clay
---
Clayburn W. Juniel, III
Effective Software Solutions
ht
This
error usually means the query was written correctly.
--
Clayburn W. Juniel, III
Phone: (602) 326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--
-
Before posting, please check:
http://www.mysql.com/ma
; occur on
> one of my update query.
> The error code is 1053. Does anyone know what it means?
> This is what perror returns:
> Error code 1053: Error 1053 occurred.
> Any help would be greatly appreciated
> Cheers
Try
> perror 1053
and see what it says
--
Claybu
For each field you could do
SELECT field_name from your_table where SECTOR LIKE '%field_name%' .
You don't care what the result is. Only that there is a result with at
least one row of data.
--
Clayburn W. Juniel, III
Phone: (602) 326
Marc Liyanage. If that
doesn't work, you can get a source distribution and compile it your
self. When I did that I got a few errors during make and make install.
I set the -i flag to ignore errors and it compiled and ran OK.
--
Clayburn W. Juniel, III
Phone: (602) 326-77
nix systems the mysql user needs file privileges to file to be
loaded. It's probably simplest to have the file located on a local
disk (not network shared) with privileges for all to read.
--
Clayburn W. Juniel, III
Phone: (602) 326-7707
Email: [EMAIL PROTECTED]
http://Effecti
not getting the whole records in the
> table
> from the text file.
>
> Your help will be highly appreciated...
> With Best Regards...
Create a table with all the restrictions removed. No "Key", or &
of connecting
to an MySQL database if you just leave off the database name you should
be able to connect.
--
Clayburn W. Juniel, III
Phone: (602) 326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--
-
Begin forwarded message:
From: "Clayburn W. Juniel, III" <[EMAIL PROTECTED]>
Date: Fri Oct 4, 2002 10:24:06 America/Phoenix
To: "Clayburn W. Juniel, III" <[EMAIL PROTECTED]>
Subject: Re: Create table if not exists from mysqldump?
On Friday, Oct 4, 2002, at 0
mported into an existing
> database it
> does not write over tables with the same name. Does anyone know if
> this is
> possible with mysqldump and if so what option achieves this? Thanks.
add the option -n or --no-create-db. This will add IF NOT CREATE to
the sql.
--
Clayburn W. Juniel
passwords. I can't even enter the root password. I'm
> nearly giving up.
It sounds like the server isn't running. You need to start it with
cd /usr/local
./bin/safe_mysqld --user=mysql &
You may need to start the server as root.
--
Claybu
OS version 10.2 from
http://www.entropy.ch/software/macosx/mysql/
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--
-
of
> story.
If you export a FileMaker database using 'Merge' you get a delimited
text file with the first row being the column names. A program could
be created to use this first row as column names to create a table.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone:
nt.
>
> With query...
>
> SELECT hl7incom.id
> FROM hl7incom, pid_segment
> WHERE hl7incom.msg LIKE '%PID%'
> AND pid_segment.id != hl7incom.id
> GROUP BY hl7incom.id;
Did you try using '<>' instead of '!='
--
Clayburn W.
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote:
> Hello All,
>
> Could anyone help me with this issue? Is it
> possible to create/drop database using mySQL
> JDBC driver?
>
Yes.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-77
This is
> done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
> /usr/local/bin/mysqladmin -u root -h localhost -p password
> 'new-password'
try:
/usr/local/bin/mysqladmin -u root password 'new-password'
with the single quotes.
--
Claybur
running you first need to give "root" a password by
typing:
mysqladmin -u root password 'password'
Including the single quotes. Then to log in as root:
mysql -uroot -p
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707
vilege. I
> am unable to give a column level privilege.
Grant Select (colum_name1), Select (Column_name2) on
database_name.table_name to whoever@"%" identified by 'password'
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobi
a row in the columns_priv table, that will do.
You have to enter data into the tables_priv table, but NOT the db
table. I believe all the fields in the tables_priv table need to be
filled except Table_priv.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707
his :
> logging into mysql with using :
> mysql -u root -p
> then I get :
> mysql >
> now I'm using "use sample_db"
> and can do some learnings, but how can I get back before "use
> sample_db", so I
> can do a "show databases;" and see th
.
Try:
safe_mysqld -u=mysql &
or
safe_mysqld --user=mysql &
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--
---
ble. You could then drop the old
database.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--
-
Before
orary Table temp_table Select * From t1 Where ID = 'x';
Update temp_table Set ActivationDate = Now() where ID = 'x';
Insert into ti select * from temp_table where ID = 'x';
When I tried this a got a table already exist error on the first line,
but the table
ert NULL into NOT NULL column, ''
> or 0 will be inserted:
>http://www.mysql.com/doc/en/Bugs.html
>
> If you don't want to use default values, configure MySQL with
> -DDONT_USE_DEFAULT_FIELDS
Thanks for the information. I read also that MySQL AB says you should
?
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--
-
Before posting, please check:
http://www.mysql.com
t;>
"mysql -h 192.168.0.230 -u username -p" is correct. But when you
created the grant for this user, you needed to list the host as
192.168.0.230 or I think "%" might have worked.
--
Clayburn W. Juniel, III -- Effective So
ntropy.ch/software/macosx/mysql/. Download the correct one
(pre OS 10.2 or after OS 10.2). And follow the instructions. It also
seems you need to start the server as root.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile:
On Thursday, September 19, 2002, at 07:44 AM, Clayburn W. Juniel, III
wrote:
>
> On Thursday, September 19, 2002, at 03:19 AM, [EMAIL PROTECTED] wrote:
>
>> linux:/usr/local/mysql # ./bin/mysqld_safe
>> The file /usr/local/mysql/libexec/mysqld doesn't exist
>> o
On Thursday, September 12, 2002, at 09:58 PM, Clayburn W. Juniel, III
wrote:
>
> On Thursday, September 12, 2002, at 05:03 AM, philipp ringli wrote:
>
>> hi all,
>>
>> i am running OS X 10.2 and
>> this version of mysql:
>>
>> mysql> status
>
his happening?
>
> please advise,
>
> phil
>
I assume you started with:
whoever% mysql -uroot -p
Enter password: xxx
mysql>
You need to add users like this:
mysql> grant create, delete, drop, insert, select, update on
mysql> Database_Name to someone@"%" i
30 matches
Mail list logo
