Workbench provides some migration features and supports SQL Server
http://www.mysql.com/products/workbench/migrate/
On Mon, Jul 14, 2014 at 4:47 PM, Felipe Coutinho
wrote:
> Hello,
>
> I'm a web developer and I'm developing a web application on Rails. I'm
> gonna use MySQL at production (I'm u
I want to count how many time one index was used during a day, do you now how
to log it to count?
> Date: Mon, 15 Oct 2012 17:27:54 +0200
> From: h.rei...@thelounge.net
> To: mysql@lists.mysql.com
> Subject: Re: Can I measure the use of index?
>
>
>
> Am 15.10.20
Afternoon
Somebody knows how can I log or measure the index use ?
Thanks
Carlos
Hi Wes, have you double checked you character set and collation ??
http://dev.mysql.com/doc/refman//5.5/en/charset-charsets.html
The collation is which determines the sorting order.
Carlos Proal
On Wed, May 30, 2012 at 4:02 PM, Wes James wrote:
> I have mysql 5.1.62-0ubuntu0.11.1
Correct.
Carlos
On Tue, Jan 31, 2012 at 12:03 AM, kalin m wrote:
>
>
> thanks carlos. so if i go with:
>
> "grant file on user "
>
> that wont infringe on the all other privileges the user already has,
> correct?
>
>
> thanks..
>
>
&g
Hi,
You have look at the "user" table which has global privileges, "db" is
specific to each database.
Carlos
On Mon, Jan 30, 2012 at 10:56 PM, kalin m wrote:
>
>
> hi...
>
> so i have this user in the user table in the mysql db that has all the
> privi
I click on "View Contacts" it shows the following thing:
*You have 90 contacts in your mailing list. They are shown below.*
*
*
*
*
And actually, if you wonder, I count it, and there are 90 contacts on the
list...
Any help would be appreciated.
Best regards,
--
Carlos Sura.-
www.carlossura.com
David
Afaik, the connector is pure .net application, so there is no 32/64 bits
distinction; you can use it in either architectures.
Carlos
On Mon, Nov 14, 2011 at 9:23 AM, David Stoltz wrote:
> Hi Folks,
>
> I'm in need to connect from my SQL 2008R2 (64 bit) server, to my My
Swaroop:
How are you handling the connections to db ? only one, with a pool,
something adhoc ?.
It looks like the connection is only one and expires after a time out
and you get the error that there is no connection.
Carlos
On 5/2/2011 3:15 PM, Andrés Tello wrote:
Seems more a java issue
Hello,
I have this field in a table from my database that contains a lot of
information and I would like to extract only a little bit of it.
I have to parse it but need to do it directly in the sql query, ¿do you
know what kind of function I have to use, or how?
This is an example of the fiel
.
Carlos Proal
On 3/27/2011 1:14 PM, Rafael Valenzuela wrote:
Hi all:
I have installed mysql 5.0 on a debian lenny 64 bits, in vmware,but I see
that there are problems with mysql performance the server is too very slow.
any solution? or any idea?
--
MySQL General Mailing List
For list
On Thu, Nov 4, 2010 at 5:13 AM, Christoph Boget
wrote:
> I think
> it might be time to start seriously looking at Postgres...
Even though all the info you provided is extremely
exaggerated...switching all my databases to PostgreSQL has been the
best thing I've done in years. It's IMO far superior
-with-float.html
Carlos Proal
On 10/25/2010 12:15 PM, Sairam Krishnamurthy wrote:
All,
I have simple query like 'select * from table1 where
column1=-107.689878'. This returns an empty set. But there is data
corresponding to this value of column.
When I looked more into it, it
You have to round the size of the last data file (ibdata4) and add the
new ones.
You can find more information on the manual:
http://dev.mysql.com/doc/refman/5.1/en/innodb-configuration.html
http://dev.mysql.com/doc/refman/5.1/en/adding-and-removing.html
Carlos
On 9/28/2010 12:59 AM, Vokern
s the 'id' column and will be set to PRIMARY
KEY NOT NULL.
Thanks for any assistance.
-Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent wrote:
> Get this tool: http://sqlyog.com/ it rocks.
>
> There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
I can't use any graphical or 3rd party add-on's. I was hoping MySQL
had this native / built in. I guess not...
--
My
I am new to MySQL coming from PostgreSQL & noticed a really annoying
issue. When I select a database, and try to auto complete in MySQL, it
doesn't capitalize the MySQL statements.
It's irritating to me to only be able to auto complete statements like
'SELECT', 'ALTER', & 'INSERT' only if I hold d
is a limit), so i
strongly recommend using prepared statements for blobs with any database.
Hope this helps.
Carlos Proal
On 8/28/2010 1:04 AM, Andreas Iwanowski wrote:
Has no one encountered this before? There has got to be a solution, and
I still haven't found it... So if you have any i
Hi Baron
This tool works better than mytop, you solved my problem, thanks a lot
Carlos
> Date: Tue, 17 Aug 2010 10:41:23 -0400
> Subject: Re: Problem with mytop
> From: ba...@xaprb.com
> To: mysql@lists.mysql.com
>
> Carlos,
>
> Have you tried innotop instead? I
.1
Very Thanks
Carlos Caldi - DBA
I have a database called 'gaming' and with in that database there are
several tables and data. I was asked to find a module called 'ako
ldap' and disable it (setting it from 1 to 0). My question is how in
MySQL do I search for a string if I don't even know what table to
search in? I know how to sea
Guys - I am no expert but I don't think this is a DNS or rDNS issue.
All resolution appears to be working fine. When my PC (tuna) attempts
to connect to the MySQL server via MySQL Workbench, it says "Failed to
Connect to MySQL at mysql.iamghost.com:3306 with user root
Host 'tuna.iamghost.com' is no
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar wrote:
> GRANT ALL PRIVILEGES ON *.* TO username@'tuna.iamghost.com' IDENTIFIED BY
> PASSWORD 'password';
>
> *.* ie for all databases , if want on particular DB
>
> GRANT ALL PRIVILEGES ON MyDATABASE.* TO username@'tuna.iamghost.com'
> IDENTIFIED BY
I am trying to connect to MySQL server [192.168.0.100] from my PC
[10.1.10.222] using MySQL Workbench and when I test the connection, I
get the following error:
"Host 'tuna.iamghost.com' is not allowed to connect to this MySQL server."
Can someone please tell me what I need to do so I can allow r
?
>
>
I dont know the deep details on phpbb, but the account is usually setup
in a config file (there you can change root...).
Also note that mysql extension uses old style passwords and mysqli the
new ones, you can get more info on the manual:
http://dev.mysql.com/doc/refman/5.5/en/o
Is it normal behavior for MySQL command type ahead not to work unless
you have a database selected? I notice that using the tab 'type ahead'
has no response unless I use a specific database. Is this normal
behavior?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Thu, May 27, 2010 at 12:26 PM, win.a wrote:
> Maybe phpmyadmin is a choice
No I am only allowed to have MySQL installed. No GUI for DBA. I am
sure there is a way to verify the privileges via CLI, I just can't
locate it on the site / documentation.
--
MySQL General Mailing List
For list archi
I would like to know how I can verify what privileges have been
granted to a specific user on MySQL. I don't remember if my user
'carlos' has specific privileges on 'mydb' database. I am sure I could
simply re-run the following command:
GRANT ALL PRIVILEGES ON mydb
Hi Mike, you need to query the information_schema schema/database that
contains the database dictionary.
You can read the manual or a beautiful diagram here:
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html
Have a nice day
Carlos Proal
On 5/11/2010 11:06 AM, mos wrote:
At 10:53 AM
I downloaded a MySQL script that backs up all my databases
automatically which looks to work amazing. My question is in this
particular script (linked below) there is a section to add a user name
and password for someone who has access to the databases I am
attempting to backup with the script. Now
ch would work
or if the 'backup' user would require high level privileges.
-Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
re info see the link
http://dev.mysql.com/doc/refman/5.0/en/select-into-statement.html
Carlos Caldi
> Date: Wed, 28 Apr 2010 14:11:14 +0200
> From: ma...@psb.vib-ugent.be
> To: mysql@lists.mysql.com
> Subject: remote mysqldump to csv (--tab)
>
> Hi all,
>
> posted t
I couldnt start it, and i did not uninstall it). I
believe you can verify the status by using #aptitude search mysql-server
and checking if its 'i' or 'c' by the left corner of the terminal window and
the package name.
So, after fixing it by dpkg, the socket came back to its pr
e.
Does anyone have any clue to work this around? I couldn't find on google.
Hope I did not post on the wrong list.
Thank you,
Carlos Andrade
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman wrote:
> On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens
> wrote:
>>
>> hearing from many admins that MySQL expects and needs there to be
>> three accounts for root. Them being 'localhost', 127.0.0.1, and
>
Today I installed MySQL 5.1.45-1 on my production server and it
recommended that I run the following:
/usr/bin/mysql_secure_installation
When I ran this, it simply guided me to do the following:
- set root password
- disable remote login for root
- remove 'anonymous' user accounts
- delete 'test
John
I think you can do this way on shell:
mysql -h db_server -u user -pPASSWORD -e "truncate table
table1"
Carlos Eduardo Caldi
> Date: Tue, 16 Mar 2010 14:12:42 -0700
> From: joli...@john-oliver.net
> To: mysql@lists.mysql.com
> Subject: Trancate t
nd disadvantages, but as a new
DBA is good to get involved in this concepts and comparisons between dbms.
Carlos Proal
On 3/16/2010 12:46 AM, Machiel Richards wrote:
Hi all
Maybe someone can assist me with this one.
A while back I requested some inf
On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey wrote:
> Please read the tutorial, let us know if you have questions on the
> information in it:
> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
Thank you very much for the link...
I did:
UPDATE sun SET serial = '0123456789' WHERE Model = 'Ul
I know this is very basic for most on the list but I need some MySQL
help. I am logged into my database and I successfully changed a 'field
type' from INT to VARCHAR. Now I need to modify the actual data I
inserted into those specific fields. I checked the manual and could
not really gather exactly
On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards
wrote:
> DELETE FROM mysql.user WHERE user='';
> FLUSH PRIVILEGES;
That worked and I thank you however I am wondering why the MySQL guide
was incorrect? Perhaps it's right but I did something wrong. Any
thoughts?
--
MySQL General Mailing List
Fo
I installed MySQL 5 today and started by setting up root passwords for
all three root accounts:
mysql> select User, Password, Host, Create_priv from user;
+--+---+---+-+
| User | Password | Host |
I am looking for a front end application that will allow me to enter
in all my server / workstation data into a MySQL backend running on
Linux. I have been told that I need to take all 75 servers we have in
our server room and keep a database of the following:
- Make
- Model
- O.S.
- I.P.
- Hostna
n
I safely remove this account? I don't understand why it's there. I
don't want to break MySQL even though there is no data or databases on
this machine but I would like to keep this as clean as possible.
Thanks for any input.
-Carlos
--
MySQL General Mailing List
For list archives
I dont know if this can help, but if you are on unix/linux you can call
cat after the dump and easily you can get the output to the stdout
ie:
$ mysqldumptempfile.txt... && cat tempfile.txt
Carlos
On 2/20/2010 9:03 PM, Yang Zhang wrote:
Hi, I'm interested in piping out the
On 2/11/2010 11:47 AM, kebede teferi wrote:
Could any one lead me to a true link where I can download the world.sql sample
database? Thanks.
http://dev.mysql.com/doc/index-other.html
Carlos Proal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Have a nice day
Carlos
On 2/2/2010 10:22 AM, ishaq gbola wrote:
Hi Guys,
I have forgotten the root password on mysql database installed on a windows
machine, how can I reset this password. I have tried un-installing and
re
Error 2 is "No such file or directory"
So, probably the file is not in the right path or you need to explicitly
provide the path to the file.
Carlos
On 2/1/2010 5:38 PM, kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a
) in the config file, and
you may need to change those too.
Carlos
On 1/28/2010 9:25 PM, Lucky Wijaya wrote:
Is that all ? So, if i changed datadir on the config file, whenever i
create databases mysql will store it on selected directory ? How about
the created-before database ?
Btw, I'm
Krishna
I dont have any benchmark but you can take a look on the Cafepress
presentation that includes some data (or ask the authors for deep reference)
http://assets.en.oreilly.com/1/event/2/Horizontal%20Scaling%20with%20HiveDB%20Presentation.pdf
Carlos
On 1/22/2010 11:44 PM, Krishna
Absolutely, check for the variable "datadir" on the config file (my.ini
on windows and my.cnf on *nix).
Carlos
On 1/28/2010 9:12 PM, Lucky Wijaya wrote:
Hi all,
I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want
to know if there's a way to
Google for "data generator", there are free and commercial solutions
available.
Carlos
On 1/28/2010 5:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name, company, address, email,
web, phone, fax. ZIP codes and area codes and street addresses
you:
http://datacharmer.blogspot.com/2009/04/test-driving-spider-storage-engine.html
http://datacharmer.blogspot.com/2009/07/sharding-for-masses-spider-storage.html
Carlos
On 1/22/2010 4:47 AM, Krishna Chandra Prajapati wrote:
Hi List,
I am looking opensource tool for mysql sharding. One is mysql-proxy,
Hi Johny
Do you have the my.cnf configuration file ?? that can simplify things.
Carlos
On 1/20/2010 3:32 AM, Johny Brawo wrote:
Hello!
I got all data files (ibdata1, ib_logfile, etc) recovevered from mine
old Debian 3.1 box (and i dont know MySQL version :( ). I want to get
that DB running
Hi !!
You need a left join and then an insert.
Please read: http://dev.mysql.com/doc/refman/5.1/en/join.html or google
for tutorials on left join
And tell me if you have further questions
Carlos
On 1/19/2010 1:00 PM, Intell! Soft wrote:
Hey
Not really quick ;> - But nobody knows
delete statements?
Im trying to figure out whats wrong.
Carlos
On 1/18/2010 11:06 PM, Manasi Save wrote:
Dear Carlos,
Thanks for the response. But I haven't gave any privileges besides
repl_slave priv to user replication and replication2 respectively.
So does that amke any difference rea
is x is replication and replication2 respectively.
Carlos
On 1/18/2010 1:35 AM, Manasi Save wrote:
Hi Anand,
Please find below my configuration file of both the masters:
ON MASTER 1:
[mysqld]
datadir=/var/lib/mysql/
socket=/var/lib/mysql/mysql.sock
old_passwords=1
log-bin=/usr/local/my
a
"multivalued attribute" and all those should be avoided. But again, is
up to you.
Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Wed, Jan 13, 2010 at 1:14 PM, Jim Lyons wrote:
> I have a script that does this. It goes through every table in every
> database (excluding specific database like information_schema, etc) and
> issues the command:
>
> select 1 from . limit 1;
Interesting. Would you mind sharing the script? Is
Yep, It might not be needed to sync, but its better to double check ;).
Carlos
On 12/23/2009 2:44 PM, Claudio Nanni wrote:
In this case it should not be needed to sync the slave,
Resetting the master basically broke the 'pipe' but events are still
on the new binary logs, it might
t;change the slave to point to the master new position
>start the slave
Hope this helps.
Carlos
On 12/23/2009 2:20 PM, Daevid Vincent wrote:
I got an alert that one of the drives was filling up (3% free). So I
figured out that a large chunk was from /var/log/mysql
r...@pse10:~# find / -type d
I already set the root password for the MySQL root user. That is why
in my 1st email you see the encrypted password listed for root in
localhost, mail, & 127.0.0.1.
Thanks for all your info. I followed Neil's steps and it worked
perfect...after I realised that those were two 's and not a single
qu
950C428 | 127.0.0.1 | Y |
|| | localhost | N |
|| | mail | N |
| carlos | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | localhost | N |
++---+---+-+
I see
Yes, you only have to delete the directories.
Carlos
On 11/12/2009 8:16 AM, Miguel Cardenas wrote:
Hello
I noticed that mysql 6 alpha is no longer available so I want to
remove it from my laptop and install the latest 5.x version. I have
just restored my Linux system image so my database is
Hi Tomasz
There are several solutions for this, one of them, maybe the most
popular, is MySQL proxy, take a look to see if solves your issues.
http://forge.mysql.com/wiki/MySQL_Proxy
Carlos*
*
On 10/25/2009 12:41 PM, Tomasz Chmielewski wrote:
With PostgreSQL, I can use pgpool2[1] tool as a
that right? I'm not sure if COLUMN_NAME is "uid" or "id" or maye
something else, and since I can't pipe it through more or less... :-)
Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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='carlo
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 thin
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;
+-+
|
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
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'@'loc
t User, Host from user;
+++
| User | Host |
++----+
| carlos | localhost |
| root | localhost |
+++
2 rows in set (0.01 sec)
I obviously from above have a user name 'carlos'@'localhost' & when I
try to delete hi
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
This might help
http://dev.mysql.com/doc/refman/5.0/en/repair.html
Carlos
On 8/10/2009 11:51 PM, Ron wrote:
Hi All,
why do i have this error. i have recently setup a mysql cluster, i now
have around 60 tables on it. when i create a new one, it gives me this
error.
ERROR 1005 (HY000
Are you sure that root has granted access to connect remotely ??
Carlos
On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote:
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option
On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivan wrote:
> Carlos,
>
> I think this does what you want: (untested though)
>
> UPDATE identities
> SET email=replace(email, 'mail.', '')
> WHERE email like '%mail.iamghost.com'
That worked perfect!
I know this seems very basic and I checked Google before posting but
it appears that many of the manuals / guides online reference
something a bit more extreme than what I am looking for.
I am searching a table called 'identities' and in that table there is
a column called 'email'. Some people hav
softwares installed in my machine and
one of these softwares might be generating some kind of MySQL conflict ( I
guess ).
- Original Message -
From: thomas.william.anth...@googlemail.com
To: Carlos A. Octaviano ; mysql@lists.mysql.com
Sent: Friday, July 17, 2009 9:25 AM
Subject:
Hello,
I've downloaded and installed MySQL 5.1 on the machine where I work.
However, during the server configuration thru MySQL Instance Server Config
Wizard, on the screen "Ready to execute...", the following error occurs in the
"Start service" point: Could not start the service MySQL:Error 0.
I
se are not relevant for
your purpose, right ?
Carlos
On 7/14/2009 9:08 PM, Daevid Vincent wrote:
-Original Message-----
From: Carlos Proal [mailto:carlos.pr...@gmail.com]
Sent: Tuesday, July 14, 2009 5:13 PM
Another thing you can do is simply erase the innodb logs.
If the dbms
Uppps i mean...useless instead of useful.
On 7/14/2009 7:11 PM, Carlos Proal wrote:
Another thing you can do is simply erase the innodb logs. If the dbms
really was shutdown properly then the logs are useful,
they will be recreated again and you can go forward with your demo.
Carlos
On 7
Another thing you can do is simply erase the innodb logs. If the dbms
really was shutdown properly then the logs are useful,
they will be recreated again and you can go forward with your demo.
Carlos
On 7/14/2009 6:23 PM, Daevid Vincent wrote:
Not sure what you mean "start it agains
Did you deleted the data dir (inside Program Files) after uninstall ?? i
think that is was not empty and when the new install tries to set up
finds it and get messy (maybe because the 32 and 64 bit issue).
Carlos
On 7/13/2009 11:07 PM, Edward Diener wrote:
I had previously installed the 64
les integrity) if it is, then
restore the default value so the next restart would make the recovery if
neccesary.
Hope this helps.
Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Yup. That was what I was looking for. Thanks!
On Mon, Jul 13, 2009 at 3:27 PM, Ray wrote:
> On July 13, 2009 12:03:49 pm Carlos Williams wrote:
>> If I am looking for a application that will connect to MySQL and allow
>> me to make database / table / user / permission modi
If I am looking for a application that will connect to MySQL and allow
me to make database / table / user / permission modifications via a
graphical tool, is there something specific out there you guys
recommend? I have been doing everything via CLI only and would like to
try a GUI option if availa
Take a look on the my.ini to see if there is something wrong (maybe a
path pointing to a missing place or memory setting bigger than your
actual RAM)
Carlos
On 7/11/2009 12:17 PM, Gary wrote:
Not sure if this is it, it was the only .err file that I have. Also this
seems to be the latest
You have to take a look on the error log, a file named hostname.err
(hostname=your machine name) and should be located inside
the mysql dir on the xammp dir.
That file will give an insight about the problem, or you can post the
error here to get help.
Carlos
On 7/11/2009 11:52 AM, Gary
, obviously a nice development IDE like Eclipse or Netbeans :)
Carlos Proal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Mon, Jul 6, 2009 at 11:33 AM, Blog Tieng Viet wrote:
> Dear All,
>
> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
> problems related to thread management. And 1 year ago, I found that my
> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
> becaus
1 | 0 |1 | Carlos Williams | |
car...@ideorlando.org | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@ideorlando.org | | | NULL | 0 |
2 |
|
1 | 0 |1 | Carlos Williams | |
j...@mdamusic.com | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@mdamusic.com | | | NULL
| 0 | 2 |
|
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni wrote:
> I don't know if you are now more ore less confused!
>
> Claudio
I would say less because you basically explained that I need to have
localhost & 127.0.0.1.
Now my problem is that no longer have this and would like to know what
I can do to re
Can someone please explain why I have 3 entries for root or if this is
normal behavior for MySQL? I thought after a installation of MySQL,
you normally have 2:
1 - localhost
2 - host.domain.com
For some reason I had a 3rd entry:
3 - 127.0.0.1
I don't know if I did the right thing but I ran the
On Thu, May 14, 2009 at 7:01 PM, Douglas Nelson wrote:
> try running the command like this
>
> select * from user where user='root' \G
>
> Capital G is a must.
I did the following:
[r...@mysql ~]# /etc/init.d/mysqld stop
Stopping MySQL:[ OK ]
[r...@
On Thu, May 14, 2009 at 7:06 PM, Carlos Proal wrote:
>
> The machine mysql.unixslut.com is not the same than localhost, right ??,
> If you only need root access from localhost you can delete the first row
> (delete from user where user='root' and host='mysql.unixsl
The machine mysql.unixslut.com is not the same than localhost, right ??,
If you only need root access from localhost you can delete the first row
(delete from user where user='root' and host='mysql.unixslut.com';)
Carlos
On 5/14/2009 5:55 PM, Carlos Williams wrote:
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal wrote:
>
> Check how many root rows do you have on the user table (select * from user
> where user='root';), some times there are several rows with different grants
> and probably you are going through and invalid rule.
I chec
Check how many root rows do you have on the user table (select * from
user where user='root';), some times there are several rows with
different grants and probably you are going through and invalid rule.
Carlos
On 5/14/2009 5:39 PM, Carlos Williams wrote:
On Thu, May 14, 2009
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal wrote:
>
> Hi Carlos
>
> Try this
>
> mysql> update user set password=password('letmein') where user='root';
>
>
> This way the password is saved encrypted, thats the way is compared when you
>
1 - 100 of 304 matches
Mail list logo
