Is there a planned release date for MySQL 8.x generally available release?
I was not able to load a function in udf_example.so. The response to
CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so';
is
Error Code: 1126. Can't open shared library 'udf_example.so' (errno: 0
/usr/lib64/mysql/plugin/udf_example.so: cannot open shared object file: No
such file or
f I'm not mistaken that's all that Master/Master is? Is there anything
else I need to worry about really, in terms of achieving HA?
Not sure if I'm oversimplifying this
Thanks,
Tim
On Wed, Jul 22, 2015 at 10:38 AM, Reindl Harald
wrote:
>
>
> Am 22.07.2015 um 16:24 sch
|
| gtid_binlog_state | |
| gtid_current_pos | |
| gtid_domain_id | 1 |
| gtid_ignore_duplicates | OFF |
| gtid_seq_no| 0 |
| gtid_slave_pos | |
| gtid_strict_mode | OFF |
| last_gtid | |
+-
pt/mysql/ca-cert.pem*
*ssl-cert=/opt/mysql/client-cert.pem*
*ssl-key=/opt/mysql/client-key.pem*
And if I remove the client certificate options in bold above, the mysql
service will start up without any problem
[client]
#ssl-ca=/opt/mysql/ca-cert.pem
#ssl-cert=/opt/mysql/client-cert.pem
#ssl-key=/opt/mysql/client-key.pem
"/etc/my.cnf" 32L, 864C written
[root@db1:~] #systemctl start mysql
[root@db1:~] #lsof -i :3306
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 4558 mysql 16u IPv6 106308 0t0 TCP *:mysql (LISTEN)
I used this method to create the cert and keys that are causing the error:
openssl req -newkey rsa:2048 -days 1000 -nodes -keyout client-key.pem >
client-req.pem
openssl x509 -req -in client-req.pem -days 1000 -CA ca-cert.pem -CAkey
ca-key.pem -set_serial 01 > client-cert.pem
I'm not really sure why these errors are occurring. Can someone please
offer some advice on how to get past this problem?
Thanks,
Tim
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
/client-cert.pem
ssl-key=/opt/mysql/client-key.pem
Any idea why that's happening or how to correct it?
Thanks,
Tim
On Tue, Jul 21, 2015 at 4:25 AM, Reindl Harald
wrote:
>
> Am 21.07.2015 um 05:03 schrieb Tim Dunphy:
>
>> I see absolutely NO indication as to why the login for th
Hey all,
I need to setup replication via SSL. 2 nodes master/master for H/A. Then 2
slave nodes for backup. Node 3 will slave off of node 1, and node 4 will
slave off of node 2 for redundant backups. Nodes 3 & 4 will store backups
to a directory mapped to S3 via S3FS. All nodes are physical.
We'
* h...@tbbs.net [150401 15:22]:
> On 2015/04/01 16:09, Tim Johnson wrote:
> >Using Mysql 5 on darwin (OS x).
> >This command
> >SELECT schema_name FROM information_schema.schemata WHERE
> >schema_name NOT IN
> >('mysql','information_schema'
ed in the tuple.
This command
mysql -uroot -p** -e "SELECT schema_name FROM
information_schema.schemata WHERE schema_name NOT IN
('mysql','information_schema','performance_schema')"
gives me a a dump of the entire mysql help screen, _not_ the
databases I a
* Reindl Harald [141005 13:12]:
>
> Am 05.10.2014 um 21:29 schrieb Tim Johnson:
> >I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The
> >ubuntu system has failed and I am unable to boot it.
> >
> >I have one database on the ubuntu partition that
Good tip.
> I've had good experiences moving MyISAM files that way, but bad
> experience moving INNODB files. I suspect the latter are more
> aggressively cached.
They are MyISAM ...
Thank you
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.
hurt myself" sort of question: Are
there any caveats and gotchas to consider?
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
; version of the alter table syntax
from. Definitely not sweatin' this detail tho, I am totally fine with what
you showed me that works.
Thanks again for your input!
Tim
On Sat, Jun 28, 2014 at 9:14 PM, Jesper Wisborg Krogh
wrote:
> Hi Tim,
>
> > -Original Message-
>
answer in that thread too suggests that this is wrong. So is the
Head First SQL book just referring to an outdated syntax that doesn't work
anymore? I can't imagine that it never worked if it's in that book. But hey
ya never know! ;)
Thanks
Tim
On Sat, Jun 28, 2014 at 7:46 P
l(7,2) | YES | | NULL||
++--+--+-+-++
7 rows in set (0.01 sec)
I appreciate your suggestions so far and it would be great if I could get
some help with this one too.
Thanks
Tim
On Sat, Jun 28, 2014 at 1:34 PM, Tim Dunphy wrote:
> Cool guys, that did it..
>
>
Cool guys, that did it..
ALTER TABLE car_table MODIFY COLUMN color VARCHAR(10) AFTER model;
For some reason the book I'm following doesn't specify that you have to
note the data type in moves! This helped. and thanks again.
Tim
On Sat, Jun 28, 2014 at 1:24 PM, Carsten Pedersen
wr
Hello,
I'm trying to use a very basic alter table command to position a column
after another column.
This is the table as it exists now:
mysql> describe car_table;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--
* h...@tbbs.net [140407 23:09]:
> >>>> 2014/04/07 08:02 -0800, Tim Johnson >>>>
> 2)mysqldump forces all database names to lower case in the "CREATE
> DATABASE" statement. I know, one shouldn't use upper case in
> database names, but :) t
* shawn l.green [140407 07:05]:
> Hello Tim,
>
> On 4/4/2014 10:27 PM, Tim Johnson wrote:
> >* Tim Johnson [140404 17:46]:
> >>Currently I'm running mysql on a Mac OSX partition.
> >>
> >>I have installed an ubuntu dual-booted partition and put
* Tim Johnson [140404 17:46]:
> Currently I'm running mysql on a Mac OSX partition.
>
> I have installed an ubuntu dual-booted partition and put mysql on
> it. I have already set up a mysql user on the ubuntu OS.
>
> In the past I have used mysqldump with just the --al
linux partitions.
I'm wondering if I should explicitly exclude some of the tables from
the mysql database. If so, which? perhaps mysql.user?
thoughts? Opinions?
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
--
MySQL General Ma
If you are looking for great compression another option is TokuDB. It
supports quicklz, zlib, and lzma compression.
On Wed, Sep 18, 2013 at 2:30 AM, Manuel Arostegui wrote:
> 2013/9/17 Wayne Leutwyler
>
> > Hello List,
> >
> > I have a customer who is wanting to use the Archive Engine. I have
.cnf.
>
> What am I doing wrong?
>
> Regards,
>
> Miguel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Thanks,
Tim Pownall
Linux Systems Performance Specialist
610-621-9712
pownall...@gmail.com
Thanks for the information, I'll give it a try myself.
On Thu, May 23, 2013 at 5:02 AM, Manuel Arostegui wrote:
>
>
>
> 2013/5/22 Tim Callaghan
>
>> Rafal,
>>
>> I don't believe TRIM is supported for XFS.
>>
>
> I tried this two weeks
ially on SSD.
The benefit of ext4 on SSD (on newer kernels) is that it supports the TRIM
functionality (add discard to your /etc/fstab file for the particular file
system). I don't believe TRIM is supported for XFS.
-Tim
On Wed, May 22, 2013 at 2:55 AM, Rafał Radecki wrote:
> Hi A
Mysql is used by just about every web host and is one of the most common
database servers around the world. I do not have any intent to stop using
mysql unless they start charging for it which I do not think will happen.
Thanks,
Tim Pownall
Sr. Linux Systems Monitoring
Hostgator.com LLC
On Tue
* Reindl Harald [121031 17:22]:
>
>
> Am 01.11.2012 01:54, schrieb Tim Johnson:
> > * Reindl Harald [121031 08:12]:
> >> you MUST NOT use "localhost" if you want to connect to
> >> a different mysqld-port because "localhost" is unix-s
* Reindl Harald [121031 08:12]:
>
>
> Am 31.10.2012 16:34, schrieb Tim Johnson:
> > * Johan De Meersman [121031 07:10]:
> >
> >> Given the different location of the datafiles and assuming the
> >> actual drupal does work, I'm starting to suspect t
* Johan De Meersman [121031 07:10]:
> Tim Johnson wrote:
>
> >* Ananda Kumar [121030 09:48]:
> >> why dont u create a softlink
> > From /opt/local/var/db/mysql5/ to /opt/local/var/db/mysql5/ ???
> >
> > I can try that, but I am doing things to MySQL tha
ould not see from documentation how to invoke
mysql or mysqldump with a specific my.cnf.
See my response to your other email.
thanks Johan
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://lists.m
* Tim Johnson [121030 10:40]:
> OP :
> * Tim Johnson [121029 16:28]:
<...snip>
> > I want to back up the mysql data for drupal.
> > However, I can't locate those databases and tables using MySQL
> > server or PHPMyAdmin, even if I start mysql on port 3307.
&l
OP :
* Tim Johnson [121029 16:28]:
> I've recently unstalled drupal 7.15 on Mac OS X 10.7.
>
> I want to back up the mysql data for drupal.
> However, I can't locate those databases and tables using MySQL
> server or PHPMyAdmin, even if I start mysql on port 3307.
>
* Hassan Schroeder [121030 08:25]:
> On Tue, Oct 30, 2012 at 9:12 AM, Tim Johnson wrote:
>
> > I might try cp -p -r, but need a second opinion.
>
> If you want to dump one or more databases, presumably you know
> the name(s); just use the mysqldump utility. Copying files
ing to do with drupal.
After all, I am just "playing with" drupal.
I'd welcome your elaboration or a second opinion.
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://lists.
That makes sense. I see from
http://drupal.org/node/22281 that there are backup and DB admin
modules. I will take a look at them.
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://lists.m
etup. I
didn't have this problem when I played with drupal on ubuntu.
"""
Great minds run in the same gutter.
-- Alaskus Curmudgeous
"""
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
* Shawn Green [121030 09:01]:
> On 10/30/2012 12:34 PM, Tim Johnson wrote:
> >... snip ...
> >
> > Clearly, I have failed to pose my question clearly, because the
> > responses indicate that I have not been understood
* Tim Johnson [121030 08:37]:
> *
> I remain as dumb as ever, but I hope I have made myself clearer
> regards
To elaborate further : See this entry from mysql --help
"""
Default options are read
mysqldump does not recognize the drupal databases!
Example :
linus:prj tim$ mysqldump event -hlocalhost -utim
-pXX > event.sql
mysqldump: Got error: 1049: Unknown database 'event' when
selecting the database
mysql does not find the drupal databases!
PHPM
* 小刀 <13488684...@163.com> [121029 18:43]:
> You can the the /etc/my.cnf and file the parameter about the data_dir
I'm sorry. I don't understand.
I might try cp -p -r, but need a second opinion.
BTW: No need to CC me.
thanks
--
Tim
tim at tee jay forty nine dot com o
15-0/mysql/data
as opposed to /opt/local/var/db/mysql5 for
'customary' mysql.
How can I accomplish this?
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Not sure how the .sql backup file would have done that, but it seems to
be working now. I'll just step away slowly and carry on. Thanks for
the help!
On 10/25/2012 2:45 AM, Nitin Mehta wrote:
Hi Tim,
It looks like your '.sql backup file' has changed the password for root u
cept a password. This is a fresh install
again, so there's not a lot of pain in uninstalling and reinstalling.
Any thoughts on why this is happening, or more importantly, how to
correct the problem?
TIA,
-Tim
going to try this again tomorrow: shutting down MySQL completely,
creating a ZFS snapshot, and rsync'ing the snapshot over to the slave
server. I did this once before unsuccessfully, but I'll do it one
more time just to be sure.
--
Tim Gustafson
t...@soe.ucsc.edu
831-459-5354
Baskin Engine
? Or perhaps does that also only work for
MyISAM tables? If so, that ought to be called out more clearly in the
documentation.
--
Tim Gustafson
t...@soe.ucsc.edu
831-459-5354
Baskin Engineering, Room 313A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
t in one statement ("LOAD DATA FROM MASTER"), but they
dropped it because of the difficulties in getting all the master data
that way.
--
Tim Gustafson
t...@soe.ucsc.edu
831-459-5354
Baskin Engineering, Room 313A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
can't be sure. I'm doing an "optimize
table" on all my tables across all my databases now to make sure
there's no weird corruption going on, but I'm not holding my breath
with regard to if that will fix anything.
--
Tim Gustafson
t...@soe.ucsc.edu
831-459-5354
is possible to block SELECT queries that doesnt have
> a WHERE statement within.
>
>
> LD
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Thanks,
Tim Pownall
G
|
| log_warnings| 1 |
+-+---+
Can someone please tell me what I am doing wrong and how I can see failed
login attempts?
Tim
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
://agiletesting.blogspot.com/2010/10/mysql-load-balancing-with-haproxy.html
I've done this a few times in the past over the years and (depending on your
setup) the combination of HA/Proxy can be dead simple to setup and rock solid
in terms of reliability.
Regards,
tim
- Original Me
a bit further (master-detail forms, etc.) -- all
> automatically, based on the table definitions and declared foreign keys.
> See www.artfulsoftware.com.
Thank you Arthur. I've downloaded it and am looking at the site.
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
ht
* Michael Dykman [120118 16:04]:
> Tim,
>
> I'm a dyed-in-the-wool console user myself.
:) As am I. Great minds run in the same gutter!
> I find the GUI tools make
> it quicker getting a project started, slower getting a project done
> so, no, I can't recommend
* Claudio Nanni [120118 15:49]:
> Hi Tim,
Hi Again Claudio:
> Excuse me but still I don't understand exactly what is the product you want
> to build.
I'm sorry, I'm not expressing myself well, I know it!
I build all sorts of web-based products...
> One thing is a
use Windows here. I've tried with Open Office, but it is not
nearly as kind to work with as Access. Do you have any other
recommendations?
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://list
* Claudio Nanni [120118 14:15]:
> Tim,
>
> are you designing a client/server application or a web based one?
Hi Claudio :
I am asking a general question. I have developed web-based apps
with mysql editing features for over 10 years now, but I am a
little lazy.
Are there any utilities available that will enable the quick design
and implementation of forms for editing and adding records?
I.E. something like M$-Access or OpenOffice form designer/wizards.
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
ice I intend to use.
Best
tim
- Original Message -
From: "Paul DuBois"
To: "Tim Dunphy"
Cc: mysql@lists.mysql.com
Sent: Saturday, January 14, 2012 6:46:38 PM
Subject: Re: delete all hosts using a wildcard
On Jan 14, 2012, at 5:23 PM, Tim Dunphy wrote:
> hello l
luding enough information last time.
best
tim
- Original Message -
From: "Krishna Chandra Prajapati"
To: "Tim Dunphy"
Cc: mysql@lists.mysql.com
Sent: Thursday, December 1, 2011 9:03:46 PM
Subject: Re: delete syntax
delete from mysql.user where user='mail_admin'
user='mail_admin';
++---+
| user | host |
++---+
| mail_admin | % |
I would appreciate any advice you may have.
Regards,
Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
bly not going to be very useful, but have you checked you
environment? In particular $PATH. I recently transitioned from
linux to mac lion and found out after some befuddlement that some
terminal emulators provide environment variables that were not
what I expected...
--
Tim
tim at tee jay fort
* Reindl Harald [111018 23:24]:
> Am 19.10.2011 01:36, schrieb Tim Johnson:
> >> try "mysql -u tim -p"
> > Same error:
> > ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
> > password: NO)
> >> > and
* Tim Johnson [111018 17:47]:
Got this...
mysql> select host,user,password from user;
+-+--+---+
| host| user | passw
s.
>
> Sometimes you can be surprised by what you read issuing:
>
> SELECT USER(),CURRENT_USER();
linus:~ tim$ sudo mysql
Password:
.
mysql> SELECT USER(),CURRENT_USER();
+++
| USER() | CURRENT_USER() |
++
* Reindl Harald [111018 15:14]:
>
>
> Am 19.10.2011 01:03, schrieb Tim Johnson:
> > Now when I try to log in with host as localhost, user as tim
> > with 'secret' password:
> > linus:~ tim$ mysql --host=localhost --user=tim --password=secret
> > ERRO
* Mark [111018 15:14]:
> Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
Not originally, but I repeated the grant then
issued
flush privileges;
quit
and have the same problem
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft
using 5.1.57 on Mac Lion.
I've done this a dozen times, but I've missed something.
Am setting up a new mysql installation ...
I have granted a user as follows (between lines of asterisks)
****
linus:~ tim$ sudo mysql
Password:
Welc
* Brandon Phelps [111011 07:43]:
> Tim,
> Just a reminder, as I am not sure if it is documented or not;
> After you get MySQL up and running via the DMG package be sure to
> install the System Preferences pane (it didn't use to install by
> default, not sure if it does now)
* Tim Johnson [111010 15:37]:
> I familiar with mysql on linux, as of late - ubuntu.
> I am installing mysql on a mac mini, with the Lion - osx 10.7
> operating system.
>
> mysql-server was downloaded and built with macports.
> Following instructions included has not result
it may suffice if I were pointed
to initial setup instructions for Mac Lion. So far, google has not
edified me.
TIA
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote:
On 7/21/2011 22:45, Tim Thorburn wrote:
Hello,
For those keeping score, this will be the second time in the past few
months I've come upon this problem. To recap, this is happening on a
development laptop running Win7 64-bit Ultimate and
hould point out that this problem also
breaks any sites running on this dev laptop as all passwords are no
longer accepted.
Any thoughts on what may be causing this? It seems to be happening
every month or so at this point.
Thanks in advance,
-Tim Thorburn
* Dan Nelson [110618 16:33]:
> In the last episode (Jun 18), Tim Johnson said:
> > Is there an optimal 'alignment' for column widths for
> > varchar types?
> >
> > I.E., divisible by 8 or 10 or by powers of 2?
>
> No. Varchar fields are sto
Is there an optimal 'alignment' for column widths for
varchar types?
I.E., divisible by 8 or 10 or by powers of 2?
URLs to documentation would be more than sufficient.
Version 5+, linux platforms.
thanks
--
Tim
tim at johnsons-web dot com or akwebsoft dot com
http://www.akw
swords anymore.
On 6/12/2011 3:33 PM, Claudio Nanni wrote:
This happens when you use an old client / library. Can you try from
command line? Also issue: mysql --version
Claudio
On Jun 12, 2011 3:09 PM, "Tim Thorburn" <mailto:webmas...@athydro.com>> wrote:
> There'
PHP< 5.2 -
also worth looking at.
- Original Message -
From: "Tim Thorburn"
To: mysql@lists.mysql.com
Sent: Sunday, 12 June, 2011 2:50:22 PM
Subject: MySQL loses password?
Hi all,
I came across something strange today on my dev machine and thought
I'd
see if anyone here
on over the last couple days.
Any thoughts?
Thanks in advance,
-Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
r_host column
was broken up into two separate columns, "user" and "host", and if those values
would match exactly the data in the mysql.user table so that the two tables are
easier to correlate.
Thanks!
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@so
et no more information when I use
"--verbose --verbose --verbose" than when I don't.
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.edu
831-459-5354
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
t any useful debugging information, I'm having
a hard time understanding why.
As to why I didn't call Redwood Shores: I didn't realize that Oracle was in the
business of giving out free tech support. I just e-mailed the mySQL general
support list, which is usually what I do when
mysql> select version();
++
| version() |
++
| 5.1.51-log |
++
The server and the client are both running FreeBSD as follows:
FreeBSD 8.1-RELEASE-p2
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.edu
831-459-5354
--
MySQL General Mailing Lis
oing wrong?
I'm using the exact same command line options and ssl-ca file that I am using
on other clients, which can connect successfully.
(As an aside: feature request: better SSL connection debugging, please!)
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.ed
On 12/16/2010 3:42 AM, Tim Thorburn wrote:
I should mention this is Windows 7 Ultimate 64-bit. After rebooting I
installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once
MySQL was installed, I downloaded and installed the current version of
Workbench (5.2.31a). When I run
reports
with similar wording were either abandoned, or supposed to be fixed
already. Any thoughts, or should I go back to 5.1.51 and wait for the
next point release of the 5.5 line?
TIA,
-Tim
* Tim Johnson [101118 12:58]:
> * Tim Johnson [101118 11:05]:
> > using
> > mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
> >
> > I have root access to the mysql command line.
> >
> > I need to grant access to user 'username' for al
* Tim Johnson [101118 11:05]:
> using
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
>
> I have root access to the mysql command line.
>
> I need to grant access to user 'username' for all databases
> except for the mysql database for both onsite (
using
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
I have root access to the mysql command line.
I need to grant access to user 'username' for all databases
except for the mysql database for both onsite (cgi script) and
remote access.
What is the syntax?
--
Tim
tim a
On 10/19/2010 12:38 PM, Montgomery, Tammie wrote:
I had an old version of mySQL on my computer but never used it. I thought I
knew the root password but it wouldn't let me in. I went ahead and uninstalled
it thinking I would get a newer version anyway. I used the Windows interface to
uninstall
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen >.>
On 9/20/2010 10:58 PM, Tim Thorburn wrote:
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development ma
hts on what I can do now?
TIA,
-Tim
lan on changing the limit clause from "limit %d, 1" to something
like "limit 500" and then iterating through the results until I get one
that succeeds, as that is more efficient than running multiple select
queries.
Anyhow, thanks for all the good suggestions and poin
s 0, do the processing, otherwise do:
i = i + 1; continue;
and that seems to be working like a charm now.
Thanks for your help!
Tim Gustafson
831-332-1496
t...@tgustafson.com
http://tgustafson.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
column and indexed it, and set its current
value to length(image_data), and modified my "update" query to set
image_data_size correctly once the job is done.
When I run more than one compute job, they all start processing the same
job simultaneously. What am I missing?
Tim Gu
column as it's a longblob and I was
under the impression that indexing a longblob field wasn't helpful. Maybe
I should add a work_data_size field as an integer, index that, and search
for records where work_data_size = 0.
For what it's worth, the table currently has 800,000 rows in
I can't seem to
find the answer. Does anyone have any suggestions?
Tim Gustafson
831-332-1496
t...@tgustafson.com
http://tgustafson.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ve built in to mySQL for people who don't have ZFS, or
who can't use it for some reason.
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.edu
831-459-5354
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
If they're still in good health, then I suppose that I could use ZFS file
systems to allocate space for databases...it just seems that this ought to be a
feature of the database. :)
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.edu
831-459-5354
--
MySQL General M
ictions, and what we're trying to accomplish is to
prevent any one of those users from going out of control (either by accident,
due to a bug, or on purpose) and clobbering the entire mySQL server. Better to
have one "dead" database than a whole server.
Tim Gustafson
Baskin
> Given a database that is doing 90% writes, what database engine should I
> use?
You may also want to increase your key_buffer_size:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_key_buffer_size
Tim Gustafson
Baskin School of Engineering
UC Santa
engine should I
> use?
myISAM will be the fastest for this type of access, I think.
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.edu
831-459-5354
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
ow, that's the first time I've read a message on a support list that seriously
said "use another program" in response to a (IMHO) reasonable feature request.
:)
But then again, your domain name is "obviouslymalicious.com", so...
Tim Gustafson
Baskin School of E
1 - 100 of 585 matches
Mail list logo
