: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow the user to create or
d
t for me to
>> use. and following privileges are given: I am not able to create a table on
>> my own. what privileges I need to create and modify tables in this database?
>>
>> mysql Ver 14.12 Distrib 5.0.27, for sun-solaris2.9 (
?"
>
> The answer to that question is that he/she needs CREATE to create tables and
> ALTER to alter them.
>
> -Original Message-
> From: Reindl Harald [mailto:h.rei...@thelounge.net]
> Sent: Wednesday, February 27, 2013 12:55 PM
> To: mysql@lists.mysql
not able to create a table on
> my own. what privileges I need to create and modify tables in this database?
>
> mysql Ver 14.12 Distrib 5.0.27, for sun-solaris2.9 (sparc) using
> EditLine wrapper
&g
Brown, Charles wrote:
Hello. Can someone tell me if I will run into any problems?
1. If I downgrade MySQL from ver-5 to ver-4.
2. If I run replication between version 4 and version 5 of the software.
Meaning slave is version 4 and the master is version 5.
Some back ground:
We have replication
Hello. Can someone tell me if I will run into any problems?
1. If I downgrade MySQL from ver-5 to ver-4.
2. If I run replication between version 4 and version 5 of the software.
Meaning slave is version 4 and the master is version 5.
Some back ground:
We have replication implemented. Currently
On Thursday 02 August 2007, Tim Johnson wrote:
> Hi:
> I use 5.0.38 on my ubuntu desktop
> and I have to work with ver 3.23.56 on a solaris-based server.
>
> The following update query:
> UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
> wine_list.wine_ID=FRED.
Hi,
Tim Johnson wrote:
Hi:
I use 5.0.38 on my ubuntu desktop
and I have to work with ver 3.23.56 on a solaris-based server.
The following update query:
UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
wine_list.wine_ID=FRED.wine_ID;
works on 5.038, but on 3.23.56 I get the
Hi:
I use 5.0.38 on my ubuntu desktop
and I have to work with ver 3.23.56 on a solaris-based server.
The following update query:
UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
wine_list.wine_ID=FRED.wine_ID;
works on 5.038, but on 3.23.56 I get the following:
ERROR 1064 (0
Is there a reason you cannot upgrade from an early =alpha= version of 5.0 ?
I think you fill find the release versions more stable.
--
Eric Braswell
Web Manager MySQL AB
Cupertino, USA
murthy gandikota wrote:
Hi
Can someone tell me where in the file system to look for the logs?
Mysql h
Looks like I have too many connections to the database. I made sure all the
connections are closed after use. Hope this is the fix. Anyone please confirm.
Thanks
murthy gandikota <[EMAIL PROTECTED]> wrote:
Can someone please help me figure out what's in this mysqld output before
crashing:
my
Can someone please help me figure out what's in this mysqld output before
crashing:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be
Hi
Can someone tell me where in the file system to look for the logs?
Mysql has been crashing once every hour. Memory is not the issue. This is
how I start the mysql:
nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
--datadir=/usr/
local/mysql/var --user=mysql
--pid-file
On Tuesday 18 July 2006 08:23 am, Calselli, Fabrizio WI wrote:
> Hi there,
>
> After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
> (SPARC) I get the error below when I try to start the mysql server:
>
> Sun-solaris# /usr/sbin/mysqld -u mysql
>
> Err
Hi there,
After having installed the Mysql Ver. 5.0.22-standard for sun-solaris2.10
(SPARC) I get the error below when I try to start the mysql server:
Sun-solaris# /usr/sbin/mysqld -u mysql
Error #60718 Can't open and lock privilege tables: Table 'mysql.host' doesn't
ex
Yes, I know it is old & obsolete.
How do I query mysql to determine which hosts would benefit from a
FLUSH HOSTS command?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Stembridge, Michael wrote:
I have tried recompiling php 4.3.1 without "--with-mysql" on the configure
line. Doing so did not remove the builtin 3.23.49 package.
You need to run configure with the new MySQL directory explicitly
specified, e.g.
./configure --with-mysql=/usr/local/mysql_4.1.7
HTH,
-
What steps are needed to upgrade (or remove) the builtin mysql [3.23.49]
included with php 4.3.1 source?
I have mysql 4.x installed and working by itself, but php continues to use
3.23.49.
I have tried recompiling php 4.3.1 without "--with-mysql" on the configure
line. Doing so did not remove
From: "Dennis Skinner" <[EMAIL PROTECTED]>
> http://lists.mysql.com/mysql/168700
I've been searching through the 15502 messages from this
list that I have archived since Jan 16, 2004 but I must've missed this
one...
Thanks for looking it up!
Regards, Jigal.
--
MySQL General Mailing List
For
"Jigal van Hemert" <[EMAIL PROTECTED]> wrote:
>> > 040925 21:50:34 Warning: Asked for 196608 thread stack, but got 126976
>> Databases are installed. You can ignore the above warning.
>
> Egor,
>
> 1) A warning usually indicates an error that has limited impact on the
> system, but still an erro
I was attempting to install mysql ver. 4.0.21 when I encountered a
premature ending to the install as shown here:
[EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql
Installing all prepared tables
040925 21:50:34 Warning: Asked for 196608 thread stack, but got 126976
040925 21:50:34
delete test_base, test_lead from test_base join test_lead on
> (test_base.id = test_lead.lead_id);
>
> Query OK, 0 rows affected (0.00 sec)
>
>
>
>
>
> >Submitter-Id: Asim Thakker
>
> >Originator:Asim Thakker
>
> >Organization:
Data Management
>MySQL support: none licence
>Synopsis: BUG in Multi-Delete when table aliases included in query
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.3-beta-standard (Official MySQL-standard
Hello,
got this error when updating our MySQL:
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
Preparing...### [100%]
file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0
conflicts with file from package MySQL-shared-compat-4.
[mailto:[EMAIL PROTECTED]
> Sent: 07 May 2004 18:13
> To: [EMAIL PROTECTED]
> Subject: Two problems with prepared statements in ver 5.0.0
>
> Hello,
>
> I have been working with the C API in version 4.1.1. I encountered a
> problem which I thought might be resolved in vers
0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
-Original Message-
From: Ken Paradox [mailto:[EMAIL PROTECTED]
Sent: 07 May 2004 18:13
To: [EMAIL PROTECTED]
Subject: Two problems with prepared statements in ver 5.0.0
Hello,
I have been working with
Hello,
I have been working with the C API in version 4.1.1. I encountered a
problem which I thought might be resolved in version 5.0.0, so I have loaded
the RPMs for version 5.0.0 onto my development RedHat Linux system.
-
Problem 1 - can't
The only source for this info is http://service.sap.com. Login with your S- user and
download the pdf file.
BIVOL
- Original Message -
From: Rahul Mandle
To: mysql
Sent: Tuesday, April 27, 2004 8:45 AM
Subject: What is SAP R/3 Ver 4.6c installation procedure on PC?
Sir
y, 27 April 2004 15:46
To: mysql
Subject: What is SAP R/3 Ver 4.6c installation procedure on PC?
Sir,
What is SAP R/3 Ver 4.6c installation procedure on PC? What is
Partiontion requirement?RAM?HardDisk total requirement? C
Can any help me for this installtion procedure?
Regards
Sir,
What is SAP R/3 Ver 4.6c installation procedure on PC? What is
Partiontion requirement?RAM?HardDisk total requirement? C
Can any help me for this installtion procedure?
Regards
Rahul
-
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo
We are currently running production on ver 3.23. We have two db servers
that are in need of hardware upgrade. DB1 replicates to DB2.
I plan on taking DB2 offline, upgrading RAM and Processors, installing
latest RH OS and MySQL 4.0. Then replace DB1 with the upgraded DB2
making it the new DB1
I try to set thread stack with ver 4.0.14 it never success the stack
size still 128K (I can do with the same command with ver. 4.0.12 it work)
The command is put in my.cnf like this
set-variable = thread_stack = 512K
how to set with ver 4.0.14
thanks
Kittiphum Worachat
http://www.mysql.com
Kittiphum Worachat wrote:
Hi.
I try to set thread stack with ver 4.0.14 it never success the stack
size still 128K (I can do with the same command with ver. 4.0.12 it work)
The command is put in my.cnf like this
set-variable = thread_stack = 512K
how to set with ver 4.0.14
thanks
Kittiphum
Hi.
I try to set thread stack with ver 4.0.14 it never success the stack
size still 128K (I can do with the same command with ver. 4.0.12 it work)
The command is put in my.cnf like this
set-variable = thread_stack = 512K
how to set with ver 4.0.14
thanks
Kittiphum Worachat
--
MySQL General
Kittiphum Worachat <[EMAIL PROTECTED]> wrote:
>
> I try to set thread stack with ver 4.0.14 it never success the stack
> size still 128K (I can do with the same command with ver. 4.0.12 it work)
>
> The command is put in my.cnf like this
>
> set-variable = thread_s
After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows
stuff on the Mysql site with no luck.
I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for
Compile it fails looking for .c pgms
New list member and mysql newbie with first time post.
I'm running into a problem getting MyODBC ver3.51 configured on my RH7.3
server running mysql 4.0.12. Anyone happen to be familiar with this
error when configuring MyODBC:
Could not find 'libmysqlclient' from '/usr/local/mysql/lib/mysql' or
Hi,
On the "CREATE TABLE" statement some mistake in syntax is not reported.
STATEMENT:
CUT-
---
CREATE TABLE prodconfirm(IDPC INT(16) AUTO_INCREMENT
Hi.
I used MySQL for over 2 years since ver 3.22 and now use ver 3.23.49
Z9bundle with RedHat 7.3) it work fine and now I decide to upgrade to ver 4
(as production cersion) I download ver 4.0.12 but when I will start to
upgrade the new one 4.0.13 launch so I decide to up to 4.0.13 instead of
At 9:45 -0600 3/8/03, Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Description:
It is unbelievable that the MySQL ver 4.0 have so many bug, I
have been reported 2 bugs just a few days ago.
Now, I have found a bug again.
The bug is :
When I execute
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Description:
It is unbelievable that the MySQL ver 4.0 have so many bug, I have been
reported 2 bugs just a few days ago.
Now, I have found a bug again.
The bug is :
When I execute "select * from old_topic where FID=
>Description:
It is unbelievable that the MySQL ver 4.0 have so many bug, I have been
reported 2 bugs just a few days ago.
Now, I have found a bug again.
The bug is :
When I execute "select * from old_topic where FID=4 and (page=0 or page=167) order by
replytime asc limit 40;&
Hi,
Something very strange was happened on my production server where i have
mounted MySQL ver. 4.1 (latest pull on Jan 25, 12:00 GMT)
Unfortunatelly i'm not able(a...i didn't start with --log) to reproduce
the exact sequence of queries which was send to the server.
MySQL was &quo
tx - i knew the diff between prod/& 'having fun' & will stick
w/production. just wasn't sure if there were verion conflicts w/the php
& apache, or it was just user (ie. me) error in config's
per below response - that would explain why mysql gets installed 1st.
i've heard/read? to stick w/all sourc
On Fri, Jul 19, 2002 at 03:24:34AM +, Jimmy Fernandez wrote:
> Hi ALL,
> I just wanted to clarify something:
> 1. Can I upgrade the MySQL version from one older version to a newer
> version? For example if I have data base in ver 3.0 can I import over to
> newly downloaded ve
Hi ALL,
I just wanted to clarify something:
1. Can I upgrade the MySQL version from one older version to a newer
version? For example if I have data base in ver 3.0 can I import over to
newly downloaded ver 4.0 ? Will it still work ?
Can I then delete off ver 3..0 and run the old database from
Hello,
i'm running mysqld-max ver 3.23.49. When i see the
process status (ps), there are 10 processes running of
mysqld. is this fine or something wrong???
Thanks!
Ritu Singla
Everything you always wanted to know
TruthXayer,
Wednesday, April 10, 2002, 9:53:15 PM, you wrote:
T> I downloaded mysql Ver 3.23.49 binary to
T> a local directory. other than (/usr/local)
T> I changed ./bin/mysqlaccess for MySQL location, etc.
T> but for some reason it dies as soo
Hi,
I downloaded mysql Ver 3.23.49 binary to
a local directory. other than (/usr/local)
I changed ./bin/mysqlaccess for MySQL location, etc.
but for some reason it dies as sooon as starts.
I notice that some scripts and files in bin directory
Dear sir
I have a problem to install MySQL for windows on my standalone PC.
When I run 'WINMYSQLADMIN.EXE' from dos prompt or windows explorer then it
did not run and gives and error message
'Access violation at address 00040298D in module 'WINMYSQLADMIN.EXE'. Read
of address '
when I pr
Richard,
Monday, February 25, 2002, 6:08:53 PM, you wrote:
RR> I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed
RR> ver. 3.23.41 on a new server which I will eventually use to replace my
RR> old server that's running 3.22.32. I have tar'ed and ftp&#
I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed
ver. 3.23.41 on a new server which I will eventually use to replace my
old server that's running 3.22.32. I have tar'ed and ftp'ed the
datbases files over to the new server. When I copy them over to the
I've got this problem that now since I updated mysql to ver 3.23.49 and recompiled
some of my working cgi scripts Apache is complaining about a server error. Premature
end of header scripts. If I use the cgi that I compiled before the upgrade everything
is fine. It's the exact
Hello,
I just had a glance at your log-rotation file, and I think I might tell you about a
possible improvement:
In the file "mysql-log-rotate" I came across the following test case:
if test -n "`ps acx|grep mysqld`"; then
/usr/bin/mysqladmin flush-logs
fi
I th
Hello,
I just had a glance at your log-rotation file, and I think I might tell you about a
possible improvement:
In the file "mysql-log-rotate" I came across the following test case:
if test -n "`ps acx|grep mysqld`"; then
/usr/bin/mysqladmin flush-logs
fi
I th
Does someone know how to append records ignoring records that do not
meet the database restrictions (UNIQUE index field).
I can do it at the server with the IGNORE clause but that clause
that not exist in access.
TIA,
Dante
-
B
hello everybody,
we are facing strange problems since we dumped tables from 3.22.22 (isam)
mysql and imported them into 3.23.32 (myisam) last friday;
this problem also occured when we selected into outfile from 3.22.22 and
then loaded data infile to 3.23.32;
first, everything seemed to go ok; all
sachin shetty writes:
> Hi
> i have successfully installed the 3.23.39 version of mysql. but the
> 3.23.41 version throws the following error when the mysqld daemon is
> started
>
> 010815 15:14:42 mysqld started
> 010815 15:14:42 Warning: setrlimit couldn't increase number of open files
> to m
Hi
i have successfully installed the 3.23.39 version of mysql. but the
3.23.41 version throws the following error when the mysqld daemon is
started
010815 15:14:42 mysqld started
010815 15:14:42 Warning: setrlimit couldn't increase number of open files
to more than 64
010815 15:14:42 Warning:
Im running FBSD ver 2.2.8 and need to know what version
of mysql installs ans runs best on this platform.
At this time upgrading in not an option.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php
rError: 0
java.lang.NullPointerException
at MySql.init(MySql.java:43)
at MySql.main(MySql.java:13)
Exception in thread "main" Process Exit...
The version of the database is:
mysql Ver 11.11 Distrib 3.23.31, for pc-linux-gnu (i686)
The users
61 matches
Mail list logo
