hello experts
I am new to mysql. in my server mysql application is installed just like
that. there is no proper driectory strutured maintained.
now my question is. how can i find the datafiles, archive files, backup
location.
i don't have root authentication. is it possible to login to the databa
Hi!
SQL Maestro Group announces the release of SQL Maestro for MySQL 9.9,
a Windows GUI solution for MySQL administration and database
development.
The new version is immediately available for download at
http://www.sqlmaestro.com/products/mysql/maestro/
New features:
---
1.
If you have a mysql username/password you can start mysql client from the
command line and log in like so
mysql -uusername -ppassword
Where username is your username and password is your password.
Once logged in you can issue the command
Show variables like 'datadir%';
This will tell you wher
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to avoid outputtin
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to avoid outp
Hi
1. can you please explain me about mysql 5 architecture and background
process..
2. how to create a schema in mysql
3. is there anything like tablespace in oracle..
4. if yes, how to create tablespace.
5. how is storage system in mysql.
in oracle, tablespace->segment->extend->block, i
Hi,
1. can you please explain me about mysql 5 architecture and background
process..
2. how to create a schema in mysql
3. is there anything like tablespace in oracle..
4. if yes, how to create tablespace.
5. how is storage system in mysql.
in oracle, tablespace->segment->extend->block,
hi tonies
no, i don't see this portal before. for my quick view, can u please answer
my question in previous email..
thanks for ur link..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Wed, Sep 30, 2009 at 3:46 PM, Martijn Tonies wrote:
> Hi,
>
> 1. can you ple
Hello Faizal,
no, i don't see this portal before.
You didn't see " www.mysql.com " before? Geesh...
for my quick view, can u please answer my question in previous email..
I fail to see why I should answer if you don't even bother to look up these
things yourself in about 5 minutes... Is yo
I think this should work...
SELECT
b.Name AS "Boss name",
ad.Name AS "Admin name",
as.Name AS "Assistant name"
FROM Projects AS pr
LEFT JOIN
People AS b
ON b.ID = pr.Boss_ID
LEFT JOIN
People AS ad
ON ad.ID = pr.Admin_ID
LEFT JOIN
People AS as
ON as.ID = pr.Assistant_ID
WHERE pr.Project_ID = 5
Basic answers under each of your questions below
-Original Message-
From: F.A.I.Z.A.L
Sent: Wednesday, September 30, 2009 11:11 AM
To: John Daisley
Cc: mysql@lists.mysql.com
Subject: Re: iam new bee to mysql
Hi
1. can you please explain me about mysql 5 architecture and background
pro
hi tonies..
you mistaken me. I am exploring many forums and discussion. these questions
are only my doubts. iam started to explore mysql.com. but i need some quick
inputs to complete my task. if u or anyone experienced in mysql can answer
this because iam sitting in urgent task.
anyways thanks f
hi Daisley
thanks for your answers
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Wed, Sep 30, 2009 at 4:20 PM, John Daisley
wrote:
> Basic answers under each of your questions below
>
>
> -Original Message-
> From: F.A.I.Z.A.L
> Sent: Wednesday, Septemb
On Tue, Sep 29, 2009 at 11:36 PM, mos wrote:
> Why don't you just say "Drop User carlos"?
> Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user 'carlos'@'localhost';
command. Why can't I remove this u
Remove manually (delete) the user from all the privilege tables:
delete from columns_priv where user='carlos';
delete from db where user='carlos';
delete from procs_priv where user='carlos';
delete from tables_priv where user='carlos';
delete from user where user='carlos';
then a nice FLUSH PRIVI
Carlos Williams wrote:
On Tue, Sep 29, 2009 at 11:36 PM, mos wrote:
Why don't you just say "Drop User carlos"?
Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user 'carlos'@'localhost';
command. Wh
What version of mysql a you using? Drop user works differently for versions
before 5.0.2.
You could just remove the user from the mysql.user table with a delete
statement.
Regards
John Daisley
Mobile +44(0)7812 451238
Email j...@butterflysystems.co.uk
Certified MySQL 5 Database Administrator
Grant
he is trying to login as that user
then drop the user he logged in as
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sei
On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty wrote:
> Grant
>
> he is trying to login as that user
> then drop the user he logged in as
No, no and no. I clearly showed my commands including my login to
MySQL as root. I also cleanly noted I can't even login as the user I
am trying to delete.
I
hi Carloswil,
could you do below check:
1. show processlists; // is there any session logined by this user account?
2. select CURRENT_USER() ; // ensure you are logining with r...@localhost, not
the r...@%
best regards
liuyann
> Date: Wed, 30 Sep 2009 09:37:28 -0400
> Subject:
A very first thing you should do is to evaluate the storage needed by a
single row.
This can be done by summing up all columns data types length in bytes and
index lenght as well.
This should be quite accurate.
Just a tip to start:
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
Thanks again for assistance. FYI, I did track this thread down
http://ask.metafilter.com/57007/Missing-commas-in-CSV-file
(exerpt:
Maybe there is a space or something in the 14th column of the first 15 rows.
posted by. on February 14, 2007
It's a bug in Excel (not something you did wrong.)
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this case. I created a database called 'staff' and
then in that database I created one simple table:
mysql> show tables;
+-+
|
alter table it add title varchar(50);
"Carlos Williams" escreveu na mensagem
news:d80f793f0909300945n73394480j468c2cf76dc9c...@mail.gmail.com...
>I am no doubt very new to MySQL and have been studying the on line
> manual however I find it a bit complex and don't understand what it's
> suggestin
Carlos,
Get a free copy of SqlYog (Community edition).
http://code.google.com/p/sqlyog/
Mike
At 11:45 AM 9/30/2009, you wrote:
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this c
On Wed, Sep 30, 2009 at 1:11 PM, mos wrote:
> Carlos,
> Â Â Get a free copy of SqlYog (Community edition).
> http://code.google.com/p/sqlyog/
Thanks but I don't have any GUI's installed on my machine I manage the
database on or from. I am also trying to learn in case things break
and I only have
If you are very new, you may want to go through the tutorial at w3shools:
http://www.w3schools.com/SQl/default.asp
Regards,
- Robert
On Wed, Sep 30, 2009 at 11:45 AM, Carlos Williams wrote:
> I am no doubt very new to MySQL and have been studying the on line
> manual however I find it a bit com
On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni wrote:
> Remove manually (delete) the user from all the privilege tables:
>
> delete from columns_priv where user='carlos';
> delete from db where user='carlos';
> delete from procs_priv where user='carlos';
> delete from tables_priv where user='carlo
Hi
iam getting the following error while login into mysql server.
andd141# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Can someone please help me understand why I am not able to login from root?
Best Regards
Faizal S
GSM : 9840118673
Blog:
Use : mysql -u root -p (it will prompt for password) and if its not a local
host also add -h ipaddress
On Thu, Oct 1, 2009 at 11:01 AM, F.A.I.Z.A.L wrote:
> Hi
>
> iam getting the following error while login into mysql server.
>
> andd141# mysql -u root
> ERROR 1045 (28000): Access denied for us
thanks kumar..
now its working
i have another doubt
i created an user with limited privilege on particular schema.
schema name: test
*mysql> create user 'test'@'%' identified by 'test';
mysql> grant select,insert,update,delete,create,drop on test.* to 'test'@
'%';*
after that i login with 'tes
a. INFORMATION_SCHEMA is the information database ie metadata, the place
that stores information about all the other databases that the MySQL server
maintains. Inside INFORMATION_SCHEMA there are several read-only tables.
They are actually views, not base tables, so there are no files associated
wi
32 matches
Mail list logo
