 | | | MySQL General | | Have you tried
GRANT privileges ON database.* TO 'jupiter '@ '192.168.6.% ' IDENTIFIED BY
'sunrise '
See
http //www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list arSmartyone wrote
> The database used to work but then something must have broke because now it
> is suddenly Read-Only (reports Read Only when I try to add a record using
> MySQLCC).
Make root@(protected) wrote
> >Description
> >
> >
>
>
>
> >How-To-Repeat
> >
> >
>
>
>
> >Fix
> >
> >
>
>
>
>
> >Submitter-Id <submitter ID >
> >OriginatorHi all
I have Mysql 3.23.45 on linux.
while trying this command
SELECT outbox_id
FROM outbox
WHERE send_time (SELECT MAX(send_time) FROM outbox WHERE subs_id "myid ")
I encounter this "John Berman " <john_berman@(protected) > wrote
> Hi
>
> Using MYSql 4.x
>
> I 'm trying to execute the following in MySQL Control Center
>
> INSERT INTO jgsurname_index ( type surname )Hi
Does anyone know how MS_Sql creates tables for users/grants/etc?
I 'm trying to use a program that uses MSSQL (MSDE not the full server)...
I found one called sql porter http //www.realsofAt 20 10 -0800 3/13/04 Andrew Zhu wrote
>Mysql 4.0.12 on win xp.
>
>Question is the check constraint supported?
>
>Example
>create table temp (
>c1 varchar (50) check (c1 like "%@% ")
>)
The book MySQL Second Edition is now available in Russian.
Information is available at
http //www.kitebird.com/mysql-book/
Check the "translations " page.
--
Paul DuBois MySQL DocumenYou could also do this with REGEXP using [[ < ]] and [[ > ]] which are
character classes that match word boundaries including comma beginning
of line and end of line. Then finding rows which Hi Charles!
Great a little extra info is needed. Is it windows XP or 2000?
My guess would be not the server version?
What do you mean running as a server? Did you tpe something like
cd cHi all
I am using MyODBC-3.51.06 and mysql-4.1.1-alpha. I connect to the database using a COM C++ Object and query through ADO recordsets.
But the database connection changes inconsistently. I ch
This query work ok. Any suggestion on how to further optimize it?
SELECT PictureName ProdName Description SalesPrice FROM Products
INNER JOIN ProdCategory ON Products.CategoryNr
INNER JOIMichael Stassen wrote
>
> SELECT * FROM sys
> WHERE sectorID BETWEEN 1 AND 20
> OR sectorID BETWEEN 30 AND 42
>
> If that 's slow (the optimizer doesn 't like ORs) and you are using at
>
>I 'm trying to sort out a query that identifies images that are not in the
>story table (structures below). Peter Brawley has kindly pointed me in the
>right direction with the sql structure (whGiven the following query how can it be modified to return 'Cuisine '(s)
that have no rows as having a count of zero and also return a SUM of
COUNT(*)?
SELECT w.WebsiteName r.Cuisine COUNT(*)
FROryan@(protected) wrote
> .
> Hi
> After 4 hours I am finally seeing a bit of results...am a newbie in MySql
> and have just been able to setup PHPMyAdmin
> after loggin in I see the database Hi!
I 'm trying to run the following query.
"(SELECT
Priority OnDateExt OnTime OnMilli OffDateExt OffTime Name Native_SumDesc Comment
FROM history.alarm_summary
WHERE OnDateExt > DATEHi JJ
Not really a MySQL question but more a UNIX/Linux question.
<UNIX 101 >
If mysqldump encounters an error it will like all well behaved
programs write an error message to stderr. You caUPDATE `Table A` `Table B` SET `Table A`.`text` concat_ws( ' ' `Table
B`.`B-num` " from " `Table B`.`date`) WHERE `Table A`.`A-num` `Table
B`.`A-num`
Hope it works
Nitin
----- Original Mesdescribe table almost does what I need how would I get a nice clean
unformed list back perhaps \r\n separated.
--
>I 'm having trouble with sql statement to select from 3 tables.
>The first column is in ProductsPics and the rest in Products.
>(qq{SELECT PictureName ProdName Description SalesPrice FROM Produ "Ed Reed " <ereed@(protected) > wrote
> Can anyone tell me how to sort the combined results of a Union query?
> Right now I have a Group By and Order By in both of my queries that make
> up my UniAt 18 33 -0800 3/12/04 John Mistler wrote
>I am two days into troubleshooting this. I need some help badly.
>
>I installed MySQL 4.0.18 for Mac. I was able to get in at first
>
>Welcome to MHi!
try to look at your my.cnf you haven 't config it correctly!
At 05 54 p.m. 12/03/2004 Chris Sanchez wrote
>get this when i run scripts/mysql_install_db. also tried mysqld --skip-grant
>If you 've read my last email you know what the problem is but I have now
pinpointed it a bit further using the processlist feature.
[root@(protected) MBPlatforms]# mysqladmin -v processlist -p
En > Hi
>
> I need this query
>
> SELECT LEFT(FieldName 1) AS FirstLetter COUNT(*) FROM TableName
> GROUP BY FirstLetter
>
> my datas in utf8 format. I can 't get first characters of the datI am using MySQL 5.0 at the moment with a number of databases. These databases are created to learn MySQL. Some of the tables are Innodb.
I would like to remove MySQL 5.0 and install 4.0.18. What doIs this user a super user or do they only have access to a single DB?
If they are a super user try changing the password using mysqladmin -u
ackerley password 'newpassword '
If this user onlyCan someone please help me sort this out.
System info
Windows XP
Apache Server
Situation
I have done a fresh install of MySQL 4.0.18 using the windows installer.
EveryNot at this time however you could have two different slaves on the
same physical server using mysql_mutli type of configuration.
http //www.mysql.com/doc/en/mysqld_multi.html
Hope it helps
Ke |
|
|
