Hi,
I'm a DBA and we r working on a migration project (from Oracle to Mysql) and we
have decided to try using MERGE MyISam tables on MySQL, to be sure we are not
going in crash with this decission we need some consulting.
we need answer for the following questions:
1. How safe/stable are
Hello,
I am a software developer,
I am using Mysql-4.1.3b-beta-nt,
ODBC3.5.1 driver on windows PC for an
application development.
the application which i am developing is a
client-server architecture based,in which we have to
store data of the BSM(Base Station Manager of CDMA
network).
the
Dayakar,
- Original Message -
From: Dayakar [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, November 21, 2004 7:39 AM
Subject: Help needed in creating primary key ,foreign key on a varchar
datatype colum
--=_NextPart_000_000B_01C4CFBA.91C9BA80
Content-Type: text
: Dayakar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 21, 2004 12:39 AM
Subject: Help needed in creating primary key ,foreign key on a varchar
datatype colum
Hello,
I am converting my database from oracle to mysql4.1 and i want the same
structure as it is oracle like primary key
Hello,
I am converting my database from oracle to mysql4.1 and i want the same
structure as it is oracle like primary key and foreign key references etc..
In oracle i have created my primary key and foreign key references on a varchar
datatype column, so can any one help me in doing the same
On Fri, 5 Nov 2004 17:49:29 -0500, Rhino [EMAIL PROTECTED] wrote:
I'm not sure why you want to use a subquery; if MySQL is anything like DB2,
a join usually performs better than a subquery and the optimizer converts a
subquery to a join (under the covers) whenever it can anyway. Therefore,
how
SELECT Syntax Help Needed!
On Fri, 5 Nov 2004 17:49:29 -0500, Rhino [EMAIL PROTECTED] wrote:
I'm not sure why you want to use a subquery; if MySQL is anything like
DB2,
a join usually performs better than a subquery and the optimizer converts
a
subquery to a join (under the covers) whenever
Hi!
I would love some help with my syntax (or another strategy). I keep bombing.
I've simplified it. Here is the deal:
Three files:
Main: id, name
Links1: id, linkname1 (a record may or may not exist for each record in
Main)
Links2: id, linkname2 (a record may or may not exist for each
Help Needed!
Hi!
I would love some help with my syntax (or another strategy). I keep bombing.
I've simplified it. Here is the deal:
Three files:
Main: id, name
Links1: id, linkname1 (a record may or may not exist for each record in
Main)
Links2: id, linkname2 (a record may or may not exist
have you tried ?
http://www.geocities.com/jahan.geo/mysql_c_by_example.html
Ruben Safir Secretary NYLXS wrote:
On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote:
Hello,
I need to write a simple C client for a project. I am using the MySQL C
API. Attached is the code. It occassionally
On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote:
Hello,
I need to write a simple C client for a project. I am using the MySQL C
API. Attached is the code. It occassionally segfaults with no visible
pattern. Could someone help me figure out why? Or any other comments on the
Hello
right now I have a table which looks like this
(including duplicate entries)
Error Date
A0012004-07-08
A0012004-07-08
A2222004-07-08
A0012004-07-09
Now I query for the quantity one error occurs during a
day (select Date, Error,
Count(*) FROM table1 GROUP BY Date and
What you want to do is pivot your data into a crosstab report. This has
been covered several times so you should be able to find more information
if you search on either pivot table, crosstab or cross tab.
Here's how to do it for a week's worth of dates, I will let you extend it
to fit your
Hi,
I am working on mysql repliction on windows 2000.
I am trying to make the slave as master when the master goes down. When I
execute the io thread shutdown on slave after master goes down, it hangs.
Even the slave server does not stop on executing the shutdown command using
mysqladmin and
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.
--
DVP
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 7:49 PM
To: [EMAIL PROTECTED]
Subject: urgent help needed
cc
Subject
RE: urgent help needed
Hello All,
I have a database with the following (simplified) structure:
[Products]
ProductID
ProductName
[PurchaseRecords]
ProductID
CustomerID
I need to find all of the rows in the table Products which do not have
at least one corresponding row in PurchaseRecords. How do I translate
Daniel,
I have a database with the following (simplified) structure:
[Products]
ProductID
ProductName
[PurchaseRecords]
ProductID
CustomerID
I need to find all of the rows in the table Products which do not have
at least one corresponding row in PurchaseRecords. How do I translate
this
Hi!
I got a table, champions, looking like this:
idclass winner_1 winner_2 year
-
0 hd carl mattias 1957
1 hs daniel
:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 6:50 PM
To: [EMAIL PROTECTED]
Subject: SQL-help needed
Hi!
I got a table, champions, looking like this:
idclass winner_1 winner_2 year
Carl Schéle, IT, Posten wrote:
Hi!
I got a table, champions, looking like this:
idclass winner_1 winner_2 year
-
0 hd carl mattias 1957
1
hi all,
I have installed MySQL 5.0.0a-alpha for Windows...
Everday 1st time it's started using WinMySQLAdmin 1.4 tool
and working on the mysql prompt, it works fine...
whenever i shut down the system OR Stop the service once
and restart again it started asusual, but no values displayed
in
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote:
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
There are some version on
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA
Regards,
Anup Mahansaria
--
MySQL General Mailing List
For list archives:
Hi!
If memory serves me correctly, MySQL AB have stopped issuing SCO
OpenServer and SCO UnixWare binaries publicly and will only be providing
them to customers who take out commercial licences. This is probably due
to the fact that OpenServer and UnixWare cost a lot compared ot other
OSes,
Re: Urgent help needed - SCO Unix
binary
]
Subject
Re: Urgent help needed - SCO Unix
binary
Hi again,
sorry for replying to my own message, but I found the [obscure] problem.
turns out mysql doesn't like getting its gid information from an LDAP
server. There is no mention of this in any of the docs I found, but I will
do more looking this morning.
The solution was to change my
Hi folks,
just compiled up mysql-4.0.17.tar.gz on a (stock, basic install) RHEL3
system, and get similar symptoms to something I experienced a while ago
with RH9. that is... it compiles fine, but wont start.
The ./configure options are:
./configure '--prefix=/opt/local/stow/mysql-4.0.17'
Hi
I am using LOAD DATA INFILE to populate a mysql
db. I prepare the file in Excell and save it as
csv format. Every works fine... except that the
file contains special characters with accent or
symbols. Is there a way to import such text
field directly or do I need to escape all these
Hi,
I need to add a new auto field to my db, but I need to make sure the records are
listed in order of one of the other fields first which is a date field.
Any ideas how I do this would be greatly appreciated!
Thanks.
D.Hayhoe
This email has been scanned for viruses.
--
MySQL General
Hi,
I need to add a new auto field to my db, but I need to make sure the
records are listed in order of one of the other fields first which is a date
field.
Any ideas how I do this would be greatly appreciated!
listing records is in no particular order, unless you ask for an order.
SELECT
Hi,
(please reply to the list only)
Yes thanks but how do I then add a new auto number field and still keep
the order?
What order? What has an auto-number have to do with what order?
Please explain your problem in detail - it might be completely clear to you,
but we're outsiders :-)
With
Hi,
I think everyone is misunderstanding my problem as perhaps I didnt phrase it very well.
I need to add a new autonumber field to my db, but I need to make sure when the
numbers go into the field they are in the order of one of my other fields that is a
date field.
i.e. I have a field which
Hi Dominic,
I think everyone is misunderstanding my problem as perhaps I didnt phrase
it very well.
I need to add a new autonumber field to my db, but I need to make sure
when the numbers go into the field they are in the order of one of my other
fields that is a date field.
i.e. I have a
I have a problem with this query
Version MySQL 4.0.15-nt
The query gets all articles written by author but excludes those articles
which are related to products
SELECT DISTINCT
post.post_id,
post.title
FROM
c_posts post,
c_post_product prod,
* Unnar
I have a problem with this query
Version MySQL 4.0.15-nt
The query gets all articles written by author but excludes those articles
which are related to products
SELECT DISTINCT
post.post_id,
post.title
FROM
c_posts post,
c_post_product prod,
Hello,
I need to write a simple C client for a project. I am using the MySQL C
API. Attached is the code. It occassionally segfaults with no visible
pattern. Could someone help me figure out why? Or any other comments on the
code to help me make it better?
/* client.c */
#include stdio.h
Here is the corrected version:)
Take a look at Paul DuBois book. Don't use gets. Instead use fgets. That's
safe. I didn't change your gets call:)
hth,
Ganbold
#include stdio.h
#include stdlib.h
#include string.h
#if defined(_WIN32) || defined(_WIN64)
#include windows.h
#endif
#ifdef WIN32
Can anybody help me sort my results in the correct way.
My Table description is:
+--+---+--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--+---+--+-+-++
| id
Not sure I understand what you need?
Can you create a dummy output table of what you would like your result
to look like?
At first glance, from reading your question, it sounds like you simply
want this:
select * from ppc_keywords where keywords like %job% [group by
keywords] order by bid;
I think the most difficult ( if not impossible with just using mysql
query) is the part where you apply your logic as to the most relevant
keyword.
You need to be able to have a mechanism of telling the query which
keyword is the most relevant, ie, human logic says, the one that matches
the search
Hello,
I am making a avatar chat you can see some of my work and I hope you could
help me in a small area that im needing help in which is making your client
and server to be able to split avatars such as like on www.habbohotel.com
you have one user with his / her own avatar and you have another
Hi,
I'm building a planning system for a newspaper. Article ideas are defined
as articles with no deadline, no publication date or no reporter assigned.
I wan't to show all entries from table un_article that matches those three
criterias.
I have three tables:
CREATE TABLE un_article
(
a_id
anders thoresson schrieb:
I'm building a planning system for a newspaper. Article ideas are
defined as articles with no deadline, no publication date or no reporter
assigned. I wan't to show all entries from table un_article that matches
those three criterias.
I have three tables:
CREATE
G'day all,
Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that looks
like this:
ID Job Sub Task Amt
1A01 A1910,001.00
102 B53 A201 79.47
213 X99 L8838,289.02
284 A01 A19126.98
I do not have ownership and *MAY NOT*
On Fri, Jun 27, 2003 at 09:05:48AM -0400, Moulder, Glen wrote:
G'day all,
Having trouble with SUM, could use a hand. I inherited a table, Funds_Recd that
looks like this:
ID Job Sub Task Amt
1A01 A1910,001.00
102 B53 A201 79.47
213 X99 L8838,289.02
Hi Fred, group,
I wrote--
I'm trying to get just a total of the funds amount for a
Job, Sub and Task like this --
SELECT Jobs.Job, Jobs.Sub, Jobs.Task, sum(Funds_Recd.Amt) AS Amount
FROM Jobs, Funds_Recd WHERE Jobs.Job=Funds_Recd.Job and
Jobs.Sub=Funds_Recd.Sub and
Hi *
I'm running MySQl 3.23 and I'm trying to run a very simple command that
basically finds the highest number in a column and then for all matching
rows sets their card number to be current highest +1. The code looks
like this:
#cardnumb is actually a string of the form SNx so set
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 1:53 PM
Subject: Simple MySQL help needed...
Hi *
I'm running MySQl 3.23 and I'm trying to run a very simple command that
basically finds the highest number in a column and then for all matching
rows sets their card number
WHERE newphoto=1 and
tbprinted=1;, iHighNum);
This in effect leaves any processing possible to the client side.
Hope that helps,
-Shane
- Original Message -
From: Phill Gillespie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 1:53 PM
Subject: Simple MySQL help needed
.
Best of luck,
-Shane
- Original Message -
From: Phill Gillespie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 3:54 PM
Subject: Re: Simple MySQL help needed...
Shane Bryldt wrote:
I think the solution is simple, remove the part of the code you are
having
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote:
Hello All.
I am using Redhat
Hi!
On Jun 13, H M Kunzmann wrote:
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
No, this is wrong.
Any xxxTEXT field can be
Hi Herbert,
I was reading both your threats once more carefully (the original post and the
repost).
1) I assume you are using the MyISAM table format.
You wrote that you have 400 text documents with each ~3.75 MB size.
2) How is the data access trend to such documents ? Do you update them all
When mysql is indexing You can check your data file direcory and You
ca see that one file (the index) is growing in size.
I see it grow up to 8M and it stays there.
Watching this, it grows very slowly. After 5 minutes of indexing, the
file size has barely hit 2MB.
The command I use is:
Hello All.
I am using Redhat 9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where to look next.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name ft_dump).
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index index again.
Some questions:
Do You have
help needed. Please somebody
help.
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name
ft_dump).
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index index
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name ft_dump).
I agree with this :-)
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index index again.
Hello All.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a fulltext index on the table, with
alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out
Hi Kunzmann,
I might be wrong but to answer your question I think three things are
necessary:
1) we will need to know the table structure(s)
2) we wil need to know which column you indexed
3) we wil need to know which request(s) you used
Is it possible that you indexed a column in the big
Cool!. That solved my problem; I don't understand why
doing a grant all didn't fix the permissions but here
is my ant output now:
[EMAIL PROTECTED] cvebrowser]$ ant test
Buildfile: build.xml
init:
build:
jar:
test:
[echo] Testing using the following classpath:
Greetings,
I'm trying to create a database and then adding a
specialized user so it can work with it, but so far i
got no luck:
[EMAIL PROTECTED] josevnz]$ mysql -u root -p -h
localhost.localdomain
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection
mysql use mysql;
mysql update user set grant_priv = 'Y' where user = 'root';
mysql flush privileges
and reconnect to mysql server as root user and
retry grant clause. You'll be happy!!! ^^
Greetings,
I'm trying to create a database and then adding a
specialized user so it can work with it,
Hi all,
I am fairly new to SQL and this is a really complex query for me.
Here is the setup. 3 tables. tbl_personnel, tbl_personnel_dras, tbl_dra
each person in the tbl_personnel table can have 0 - 3 records in the
tbl_personnel_dras table. The tbl_personnel_dras table is just the
person_id
Charles Kline wrote:
I am fairly new to SQL and this is a really complex query for me.
Possibly more complex than necessary. Must you have a separate column
for each of the areas? If you don't mind having them all in a single
column, the query becomes simple and efficient:
SELECT p.fname,
Hello,
I have RH 6.1.
I have mysql 3.22.25 version binary installation
databases are in /var/lib/mysql
binaries in /usr/bin/mysql etc
/var/lib/mysql/mysql.pid
/var/lib/mysql/=mysql.sock
and rpm packages:
perl-DBI-1.13-1,
perl-DBD-mysql-mysql-1.22.10-1
perl-5-5.0050
and binary
On 26-Feb-2003 M Wells wrote:
Hi All,
I'm having problems creating a query to return a recordset from the
following situation:
I have two tables, one which contains member details, and the other
which contains details re: the groups to which the member belongs.
When a member logs into
Read [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 4:05 PM
To: M Wells
Cc: [EMAIL PROTECTED]
Subject: RE: Help needed with SQL...
On 26-Feb-2003 M Wells wrote:
Hi All,
I'm having problems creating a query to return a recordset from the
following situation:
I have two tables
On 26-Feb-2003 [EMAIL PROTECTED] wrote:
Yes , I had use this query statement in my MySQL server,
But I have a query about it.
Why are you use WHERE a.groupname=b.groupname AND members.id=b.memberid
AND a.memberid=1?
Can you give me a explain or give me a advise!
Sure.
mysql SELECT
: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 5:11 AM
Subject: RE: Help needed with SQL...
On 26-Feb-2003 [EMAIL PROTECTED] wrote:
Yes , I had use this query statement in my MySQL server,
But I have a query about it.
Why are you use WHERE a.groupname=b.groupname
]
Sent: Wednesday, February 26, 2003 10:56 AM
Subject: Re: Help needed with SQL...
I've never seen opening a table twice and then doing a join back with
itself. Am I wording this correctly? Is that how to describe what you're
doing?
Thanks for posting this to the full list.
- Sheryl
I need to install a mysql client only on a solaris2.8 machine, the mysql
server is on another machine.
I could not make the compile work using the source download. I got an
error in make.
Can someone point me to a binary client download somewhere? Or give me
a hint of the following compile
Hi All,
I'm having problems creating a query to return a recordset from the
following situation:
I have two tables, one which contains member details, and the other
which contains details re: the groups to which the member belongs.
When a member logs into a particular part of my site, I want to
MySQL-List,
I have just installed MySQL on a Windows 2K machine. I followed the
directions to make it secure and now I'm getting the Access Denied
error. I found in the manual that I should create a hosts file to fix
this. Where do I put it? From what I see, in the C:\mysql\bin folder,
I
- Original Message -
From: Jeremy Whitlock [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 20, 2003 5:54 PM
Subject: Access Denied Help Needed
MySQL-List,
I have just installed MySQL on a Windows 2K machine. I followed the
directions to make it secure and now I'm
C:\WINNT\system32\drivers\etc
There should be one there by default
Jerry
- Original Message -
From: Sunfire [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 20, 2003 11:32 PM
Subject: Re: Access Denied Help Needed
if i remember right you should make a hosts file in c
greetings nug
we ar estuck in a project to connect to mySQL running on Mac OS X, through
TCP/IP, please suggest
regards, ram
--
+--+
Mac Solutions
http://www.macsolutionsindia.com +91 98102 70848
On Sunday 05 January 2003 09:08, Anton Zavrin wrote:
Well, I read, played around and updated it (I guess)
Now, when I try to start mysql with this command (same as before), it
gives me that:
# /usr/local/bin/safe_mysqld --user=mysql
[1] 71491
# Starting mysqld daemon with databases from
, iConnect (Berlin)' [EMAIL PROTECTED]; 'Thomas
Spahni' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 8:08 AM
Subject: RE: MySQL Help Needed Please
Well, I read, played around and updated it (I guess)
Now, when I try to start mysql with this command (same as before), it
gives me
:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 7:01 AM
To: Anton Zavrin
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
check the hostname.err and hostname.log files in your data
directory.
Then check permissions. My sock file looks like:
srwxrwxrwx1 mysqldaemon
7970948-3
- Original Message -
From: Anton Zavrin [EMAIL PROTECTED]
To: 'Thomas Spahni' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 9:01 AM
Subject: RE: MySQL Help Needed Please
I have this file:
srwxrwxrwx 1 mysql wheel0 Jan 2 16:45 mysql.sock
I
) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 04, 2003 8:01 AM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
first thing, try:
ps [whatever options] | grep mysqld
The daemon (database server) is called mysqld, not mysql.
Regards
04, 2003 9:59 PM
Subject: RE: MySQL Help Needed Please
Did:
ps -ef | grep mysqld
got nothing
Though I can do:
# mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
#
Anything else I should try :( ?
Best Regards, Anton
, January 04, 2003 2:14 PM
To: Anton Zavrin; 'Thomas Spahni'
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Help Needed Please
Anton,
ps -ef | grep mysqld
got nothing
Because the MySQL SERVER isn't running!
Though I can do:
# mysql -u root -p
With this command, you start the MySQL Monitor (that's
Hi guys,
I'm new here and need help.
I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed
but when I'm trying to run it says:
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)' Check that mysqld is running and that the
socket: '/tmp/mysql.sock'
Anton,
check the hostname.err and hostname.log files in your data directory.
Then check permissions. My sock file looks like:
srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock
and finally check for your
socket= /tmp/mysql.sock
entries in /etc/my.cnf and
, December 17, 2002 11:53 AM
To: [EMAIL PROTECTED]
Subject: JOIN based query problem (little help needed)
Hello list.
Please help me to refine a JOIN based query which I am not
able to correct. This the scenario (simplified).
Three tables:
Products
-
| id
Hello list.
Please help me to refine a JOIN based query which I am not able to correct.
This the scenario (simplified).
Three tables:
Products
-
| id | description |
-
| 01 | bread|
| 02 | milk |
|
I am currently developing a website that would use a MySQL database to
store data. The company using this website would require users to be
able to make changes to information on the site (LIVE - database on
webserver), but they would also need to be able to make changes on their
copy (which is
john,
Saturday, November 09, 2002, 9:45:15 PM, you wrote:
j Ok.. I got the /etc/my.cnf under control, but now when I do this:
j root@rock:/etc# mysqladmin -u root -h rock password *
j mysqladmin: connect to server at 'rock' failed
j error: 'Host 'rock.biohazard.org' is not allowed to connect
I dont have a my.cnf file, so I touched /etc/my.conf still doesnt
work. Where do
I find a .cnf file to copy over?
and
root@rock:/var/run/mysql# ls
mysql.sock= it exists.
What could my problem be..? I even upgraded. I am using Slackware 8.1
with 2.4.19 kernel. Maybe that will help.
Thanks so
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL server'
Then I tried this:
root@rock:/etc#
On Sat, 2002-11-09 at 14:45, john wrote:
Ok.. I got the /etc/my.cnf under control, but now when I do this:
root@rock:/etc# mysqladmin -u root -h rock password *
mysqladmin: connect to server at 'rock' failed
error: 'Host 'rock.biohazard.org' is not allowed to connect to this
MySQL
When I start safe_mysqld , I get a command prompt back again and ps aux
shows this:
mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/rock.pid
mysql30271 0.0 0.1 10580 1024 pts/1
PM
To: [EMAIL PROTECTED]
Subject: Newbie help needed with mysql
When I start safe_mysqld , I get a command prompt back again and ps aux
shows this:
mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var
On Mon, 2002-11-04 at 18:52, john wrote:
When I start safe_mysqld , I get a command prompt back again and ps aux
shows this:
mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
Hello Inamullah,
Thursday, October 24, 2002, 12:50:27 PM, you wrote:
First of all don't send me your questions, send them to the mailing
list. I don't privide private support.
IKWell, I have just installed mysql on both wndows n
IK Linux on the same machine and i wanted to ask how i
IK can
Hi all,
I have used the following script to connect our remote database from my local
machine. The PHP script is at my local machine.
When I tried to connect the database, instead of connecting to the IP provided
in the script, it is searching the Dynamic IP of my Internet Service Provider.
101 - 200 of 329 matches
Mail list logo