 | | | MySQL on Win32 | | Hi
When I view tables I see 3 listed. When I say drop databases (the database
name) it says unknown table (the 3 tables). Even if I try drop the tables
themselves it gives the same error.
S http //dev.mysql.com/doc/refman/5.0/en/revoke.html
Ensure your admin has revoke privileges and also has the privileges that
you are trying to revoke.
For example if the admin does NOT have privilHello experts
I use MySQL 5.0.27 without problems since it was released.
But now all of the sudden my ROOT user fails with some privileges
administration tasks
--
mysql > REVOKE ALL PRIVILEGEHi all
i 've installed the newest version 5.0.27-community-nt on my windows server
yesterday and I think i
have a problem that was discussed in bug
http //bugs.mysql.com/bug.php?id 18225 and
http //buHeh. These ARE persistent animals aren 't they?
http //youtube.com/watch?v 4Dna0oWu_EU
Love you
John
Hi All
I 've been volunteered to look after a MySQL 4.0.23 database (I know it 's
old but I thought I 'd learn what I was doing before updating) which
records dial-up radius users log details and all d
Can anyone explain what this means??
(The maximum effective length of a VARCHAR in MySQL 5.0.3 and later is determined by the maximum row size and the character set used. The maximum column length isHi guys
I want to have my custome error display when there is a wrong user name or
pwd.
[code]
<?php
$host "localhost "
$user "root "
$password "test "
mysql_connect($host $user $password)
$sql "shHello!
I install mysql version 4.0.26 on my WINDOWS XP
I have error 1044 Access denied for user. When I did type use testDB
Error 1064 No Database Selected. When I did type create table test_tableGreetings
I having problem to copy data from one table (in
master-detail) to another table. Totally 3 tables
involved and below are their structures -
# Master table and I able to get the 'InvoiceI 've been running this version of mysql on my w2k3 server since it was
released without ANY problems and now want to upgrade to the latest stable
release of ver5. Would anyone know of any gotchas thatI am new to mysql. I am using the command below
select table1.colum1 table2.column1 from table1 table2 where table1.id table2.id into outfile 'c /temp/myfiles/test.txt ' lines terminated by '\r\n '
I 've been looking through "da manual " but can 't seem to find this
information.
Anybody know how many columns in a table version 4.0.16 supports?
Thanks.
David
--
MySQL Windows Mailing List
For Hi all!!! Has anyone experienced a connection problem with Query Browser? I need to connect to MySQL server (wich is in 10.21.247.175) from another machine (10.21.247.180). When I try to connect it saHas anyone experienced a character set issue 5.0. We are using MySQL 5.0.24 with Connector/J 5.0.3 with char set Latin1 and our server keeps hanging. We have not seen any server error that tell us Hello experts
I have a problem with full text search. Here is my situation
In DB I have LOG records in "maillog " table
with FULLTEXT index on "log " row.
When I do a search I do
SELECT *
Does anyone know how to restrict users from seeing the INFORMATION_SCHEMA database/data? I can 't find any explicit grants but we don 't want users to access this information.
Thanks
MelissaHello all
I have a rather large table (29 million records MySQL Administrator
shows a data length of 4 Gb) which I need to make a copy of for analysis
purposes. I 've tried using the Backup fuHi
Due to the previous poor database design now I having
trouble to create a "master-detail " relationship for
existing table with many records. The worst case is I
do NOT allow to change table struDear All
I am trying to configure "mysql-4.0.18 " on Windows 2003 server. When i run
\mysql-4.0.18\bin\winmysqladmin.exe it runs but service fail to run and
always show red light. I tried to run theI am trying to use LOAD DATA INFILE and have worked through various
problems
e.g. that with version 5 you have to specifically enable the "local " variant
in the security settings to use LOAD DATA LHi
I read the recent thread (Sept) on installing two instances of mysqld
and binding them to two different IP addresses but unfortunately I have
to develop on two different versions of MySQL and thI have a 4.0 db with hardly no aborted connections.... however I have a 4.1 db with lots. I have the INTERACTIVE_TIMEOUT and WAIT_TIMEOUT set to the same values on both db 's. Does anyone know how tHello
I don 't know if this is a proper question for this list but I do know there
are some very knowledgable people here who will be able to send me in the
right direction or inform me that I 'm offI have a script that should allow all users access. Its a login script
that will just log computer information into the db. I currently have
the script working and adding to a file but a db would beI 'm trying to take table data and display the data horizontal.... I need to take the column and show the results in one row. I have tried several different inline view (queries) and get multiple rowI 'm looking for someone to assist in translating a couple of sites from
iHTML/MSSQL to PHP/MySQL.
Anyone? Please email me off list and I 'll give you details.
thanks
Tony
--
MySQL Windows Mailing LI originally had a script that would log info into a file. I now want
to use it to log info into a db. The problem is I don 't know how to
make this work across network. How do I get someone to connCan someone please help me to figure out a correct combination of the
character sets and collations for 5.0.23 Mysql server funning on XP?
I have a previously working data xml import program that used |
|
|
