When you are in without the flag , issue the following:
Select current_user();
It should return root.
Then do this:
Grant all privileges on *.* 'root'@'%' identified by 'letmein'
It should work If you did not mess too much with grant tables.
Claudio
Il giorno 26 ago, 2009 4:36 m., "Todd Lyons"
Then which DB engine is better.
Thanks
On Mon, Aug 24, 2009 at 8:16 PM, mos wrote:
> At 05:01 AM 8/22/2009, you wrote:
>
>> Hi all
>>
>> Tell Me few Query Optimization Tips
>>
>> For example.. some people saying that , avoid using more of and condition
>> in
>> the query
>>
>
> Hu
Is there a specific reason you cannot do it with --skip-grant-table?
You should theoretically also be able to overwrite the files user.*
(there should be 3) in /var/lib/mysql/mysql/ (replace everything up to
and including teh first mysql in that path with your mysql data dir)
when the server is st
Gavin Towey wrote:
Which version of mysql are you using? In mysql 4, you could get away with some
differences between the definition of the merge table and the underlying tables.
As you've discovered, the structure and index definitions must now be exactly
the same, otherwise you will get err
>> On Wed, Aug 26, 2009 at 02:12, Joe
> wrote:
>> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
>> > really need some help regaining access to. While attempting
>> > to adjust/add remote user access, we accidentally did the
>> > following:
>> >
>> > use mysql;
>> > update user set hos
I run sudo /etc/init.d/mysql start and check the syslog by running sudo
tail -f /var/log/syslog
This is what I get
Aug 25 22:18:06 chenj-desktop mysqld_safe[10934]: started
Aug 25 22:18:06 chenj-desktop kernel: [11083.933531] type=1503
audit(1251253086.020:43): operation="inode_create" requeste
First, check the error log, if you can't find it, start mysql from the
cmd line by running safe_mysqld it should print errors to console.
If it is a permission issue, it might be caused be selinux, you'll
need to change the object type od that new directory to mysqld-
something. I can't recall the
I'm trying to get back to an earlier state where we started
mysqld withOUT --skip-grant-tables but the root user had no
password. Yes, insecure, but we're in restoration mode here.
How do I reset/revert the root password to no password without
running with --skip-grant-tables?
Thanks in advan
You might consider a full disk/volume/partition encryption maybe?
http://truecrypt.com/
I use this for my private files and it's awesome. Cross platform and can do
virtual partitions on an actual physical drive.
> -Original Message-
> From: philip [mailto:phi...@livenet.ac.uk]
> Sent:
OK, thanks, that got me in. But upon inspection, the user.host
values do not look fouled up as I thought they were (it appears
the bogus update may have aborted). But my access problem
remains
If I start with --skip-grant-tables, 'show databases' shows all
DBs. But without that flag, I only
David,
At 03:28 PM 8/25/2009, David Taveras wrote:
Hello,
We have a BSD box with the following installed:
mysql-client-5.0.77 multithreaded SQL database (client)
mysql-server-5.0.77 multithreaded SQL database (server)
p5-DBD-mysql-4.010 MySQL drivers for the Perl DBI
php5-mysql-5.2.8mysql
Hi there,
I am using MySQL on ubuntu 8.04.
I followed this link
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
to change the data directory of MySQL.
After stopping MySQL: sudo /etc/init.d/mysql stop
I make a new directory: sudo mkdir
You have to reset the permissions.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Carlos
On 8/25/2009 7:12 PM, Joe wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we
Hey Joe,
stop the server, start it with --skip-grant-tables, change the root
entry in mysql.user to your liking, and then restart the server
without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joe wrote:
> We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
> nee
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we accidentally did the
following:
use mysql;
update user set host = 'SomeBogusIP' where user = 'root';
Now, we can't get into the DB to fix
SELECT * FROM ORDER o INNER JOIN ORDER_LINE_ITEMS o_l
ON (o.id=o_l.id)
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfa
I have a basic invoice table with related line items table
Goal :I'd like to get ALL the related line items - for ALL the
'open' invoices...
-- this should get a list of open (unpaid) invoices
$query_invoice = "SELECT DISTINCT ID from invoices where status =
'open'"
-
--
Hello,
We have a BSD box with the following installed:
mysql-client-5.0.77 multithreaded SQL database (client)
mysql-server-5.0.77 multithreaded SQL database (server)
p5-DBD-mysql-4.010 MySQL drivers for the Perl DBI
php5-mysql-5.2.8mysql database access extensions for php5
We are experien
Which version of mysql are you using? In mysql 4, you could get away with some
differences between the definition of the merge table and the underlying tables.
As you've discovered, the structure and index definitions must now be exactly
the same, otherwise you will get errors.
Regards,
Gavin
Hi Deviad,
NATURAL JOIN uses all column names that are the same between both tables as
conditions.
select * from rappresentanti NATURAL JOIN clienti;
is the same as:
select * from rappresentanti r JOIN client c ON r.cognome=c.cognome AND
r.nome=c.nome AND r.vita=c.vita AND r.citta=c.citta AND
At 03:16 AM 8/25/2009, you wrote:
Hi everyone,
Is there any forseeable issue with having an extremely large data set, say 1
TB in size for a single database and doing a SELECT * FROM tbl WHERE
where are super restrictive (in that they return
only a few rows since only a few match) and the prope
On Mon, 24 Aug 2009, Mike Scully wrote:
> Hello, all.
> =20
> Can any of you share with me the names of any third-party tools or
> appliances that you are using to encrypt your MySQL databases? I am
> doing a search and would like to narrow down the initial search list.
> Thanks!
> =20
> Mike
I
On Tue, Aug 25, 2009 at 3:16 PM, Suhail Doshi wrote:
> Hi everyone,
> Is there any forseeable issue with having an extremely large data set, say
> 1
> TB in size for a single database and doing a SELECT * FROM tbl WHERE
> where are super restrictive (in that they
> return
> only a few rows since
Hi everyone,
Is there any forseeable issue with having an extremely large data set, say 1
TB in size for a single database and doing a SELECT * FROM tbl WHERE
where are super restrictive (in that they return
only a few rows since only a few match) and the proper indexes are in place?
This is on
hi, all:
i have met an question as below:
table A1,A2
A1 has been *packed by myisampack, and rebuild the index by myisamchk*
A2 is a noraml table, and the struct of A1 and A2 is exactlly same
talbe A is the merge table of A1 and A2
while i use:
*
mysql> select max(id) from A;
** ERROR 1030 (H
25 matches
Mail list logo
