ss to a mysql console on the mysql host, try this:
GRANT ALL PRIVILEGES ON .* TO 'quest'@'r2d2.dahl-stamnes.net'
IDENTIFIED BY 'somepassword';
FLUSH PRIVILEGES;
Remember to set the password in the config file accordingly...
Regards,
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
g ctrl-c would kill the client...
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sounds like you are trying to import records already present on server B.
You might want to add drop table in your dump...
Something like:
mysqldump --complete-insert --extended-insert --add-drop-table
Peter Normann
yousef albarak wrote:
> hi,
> I am try to restore many databases from
anybody would share their thoughts on any
advantages or drawbacks as to having the primary key contain meaningful
data.
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi everybody,
It appears to be usual practice from what I can see in this list to use a
primary key that actually contain somewhat meaningful data.
I have always used primary keys solely for one purpose only: To identify a
table row uniquely, using autoincremental integers. Actually, if I were to
might consider browsing mysql's site at
http://www.mysql.com. Specifically
http://dev.mysql.com/downloads/mysql/4.0.html might be interesting.
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
seName.* TO
'myUserName'@'HostNameOrIPAddressOfApacheServer' IDENTIFIED BY 'myPassword';
2. Flush the mysql server user privilege cache
mysql> FLUSH PRIVILEGES;
Now go read the manual.
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
command line
> client'.
It is not necessary to run mysql as a service, however it is necessary to
run it somehow, that being as a service or standalone application. The
command line client is still a client, thus it depends on the mysql server
being accessible.
Peter Normann
--
MySQ
ySql in the first place, but nevertheless I assume you must be establishing
the database connection first hand in your script. This being the case, you
should be able to apply a different hostname than 'localhost' in your
connection script.
Remember to verify that the grant privilege
t that install the initial tables :
(excerpts from TFM):
To initialize the grant tables, use one of the following commands, depending
on whether mysql_install_db is located in the bin or scripts directory:
shell> bin/mysql_install_db --user=mysql
shell> scripts/mysql_install_db --user=mysql
re foreign keys. Constraints are constraints. Foreign key
constraints are... well, you do the math.
So, in your opinion, MySql was never really a relational database until
whatever version enforcing refential constraints was released?
Peter Normann
--
MySQL General Mailing List
For list
UPDATE UserTable SET FullName = CONCAT(IFNULL(CONCAT(FirstName, ' '), ''),
IFNULL(CONCAT(MiddleName, ' '), ''), IFNULL(LastName,''));
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ysql 4.0.13 or later...
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Asha <> wrote:
> Is there a physical
> limitation in the InnoDb table structure as to why it can't
> support FullText indexes?
http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html
http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html
Peter Normann
--
M
find them here:
http://dev.mysql.com/downloads/mysql/4.0.html
Peter Normann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.id_secr_rqst
AND t1.name_rec_type='Exception Resource'
AND dt_aud_rec = Latest
OR dt_aud_rec = NoSoLatest
HAVING Latest > NoSoLatest
GROUP BY t1.id_secr_rqst
ORDER by t1.dt_aud_rec DESC;
I am not 100% sure about the syntax, but you might get the idea.
Peter Normann
--
MySQL Gener
mit IMO is mysql specific (I hope I am wrong) is there something
> generic so I dont need to bother about which database I am running it
> against.
As far as I know it is MySql specific. SQL Server's equivalent is SELECT TOP
2 or something.
Peter Normann
--
MySQL General Mailing List
Fo
Hi Anoop
Try:
SELECT t1.id_secr_rqst, t2.name_rec_type, t1.dt_aud_rec
FROM isr2_aud_log t1, isr2_aud_log t2
WHERE t1.id_secr_rqst =
t2.id_secr_rqst AND
t1.name_rec_type='Exception Resource'
ORDER by t1.dt_aud_rec DESC
LIMIT 2;
Peter Normann
--
MySQL General Mailing List
For lis
E B.Booking_Type = "Booking"
AND DATE_FORMAT(B.Booking_Start_Date, "%Y-%m-%d") >= '2005-01-01'
AND DATE_FORMAT(B.Booking_Start_Date, "%Y-%m-%d") <= '2005-12-31'
HAVING WEEK = MYWEEK
GROUP BY WEEK;
Supposing you have 53 records in week with num
oject_ID = "23", 1,0)) AS `Project A`,
SUM(IF(B.Project_ID = "42", 1,0)) AS `Project B`
FROM Bookings B
LEFT JOIN Projects P ON (P.Project_ID = B.Project_ID)
WHERE B.Booking_Type = "Booking"
AND DATE_FORMAT(B.Booking_Start_Date, "%Y-%m-%d") >= '2005-01-01&
Hi Jenny,
I believe that the timestamp field will automatically be set to NOW()
when you INSERT a record... In other words, you can disregard the
timestamp field in the INSERT query
Peter Normann
-Original Message-
From: Jenny Christy [mailto:[EMAIL PROTECTED]]
Sent: 30. juli
I tried the following in 3.23.49:
SELECT FLOOR((25*9.54)+0.5);
-> 238
SELECT FLOOR(238.5+0.5);
-> 239
SELECT FLOOR((25*9.54)+0.50001);
-> 239
SELECT FLOOR((25*9.54)+0.51);
-> 238
Isn't the world a funny place?
Peter Normann
-Original Message-
= 0;
Jeez either I should be getting some coffee or some sleep
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 18. juni 2002 22:21
To: Peter Normann; [EMAIL PROTECTED]
Subject: Re: Need help with a complex query
>>> Try - and I
p by... I'll have
a
look and see what I can come up with. If you know what's missing, I
wont
mind finding out :-)
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: "Peter Normann" <
OR
weather_data.Site='FAJS';
Work?
You can add LIMIT 1 to the query...
Peter Normann
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 19:00
To: [EMAIL PROTECTED]
Subject: Re: LEFT JOIN again... Although, this time I think it's a
design fl
Well, my best guess is that you should consider indexing your tables...
If you haven't done so already, indexing will cause dramatic effect on
the speed of the queries...
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 19:
You're welcome, Ian.
Being new to this list, I'm just trying to gather enough credit to get
people to look at my recent post ;-)
Peter Normann
-Original Message-
From: mySQL list [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 18:29
To: Peter Normann; [EMAIL PROTECTED]
Subj
ons.customerid
AND Subscriptions.listid='2'
AND Ordered_Items.orderid IS NULL
AND Orders.customerid IS NULL
AND NOT Customers.bad_email;
Peter Normann
-Original Message-
From: Jamie Tibbetts [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 18:23
To: [EMAIL PROTECTED]
Subject: Need help
Oops, I meant
SELECT ad_catego.* FROM ad_catego, db_subcategory
WHERE ad_catego.db_subcategory=rules.db_subcategory
AND rules.db_category_int != '2'
AND rules.db_login !='$session_login';
?
Peter Normann
-Original Message-
From: Peter Normann [mailto:[EMAIL P
SELECT ad_catego.* FROM ad_catego, db_subcategory
WHERE ad_catego.db_subcategory=rules.db_subcategory
AND rules.db_category != '2'
AND rules.db_login !='$session_login';
?
Peter Normann
-Original Message-
From: Balteo [mailto:[EMAIL PROTECTED]]
Sent: 17. juni 2
Try
SELECT Items.ItemID, Stuff.info FROM Items LEFT JOIN Stuff ON
(Items.ItemID = Stuff.ItemID && (type=0 || type IS NULL));
Peter Normann
-Original Message-
From: mySQL list [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 17:59
To: [EMAIL PROTECTED]
Subject: A LEFT OU
Sorry, I didn't read the mail through before replying... :-/
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 15:43
To: [EMAIL PROTECTED]
Subject: LEFT JOIN again... Although, this time I think it's a design
flaw rather than a query one
Hiya again
tions.MetarCode IS NULL;
Note the LEFT JOIN weather_locations in stead of weather_data
Peter Normann
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: 16. juni 2002 15:43
To: [EMAIL PROTECTED]
Subject: LEFT JOIN again... Although, this time I think it's a de
Sorry for not mentioning it, but yes I have indexed manager.Person...
Peter Normann
-Original Message-
From: httpd [mailto:httpd] On Behalf Of Joseph Bueno
Sent: 16. juni 2002 10:54
To: Peter Normann
Cc: [EMAIL PROTECTED]
Subject: Re: Help with indexing
Peter Normann wrote
--+
Any help will be appreciated, since I use this query in a number of
functions and it is a big problem...
Best regards
Peter Normann
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
35 matches
Mail list logo
