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 felipelcouti...@gmail.com
wrote:
Hello,
I'm a web developer and I'm developing a web application on Rails. I'm
gonna use
Afternoon
Somebody knows how can I log or measure the index use ?
Thanks
Carlos
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.2012 17:24, schrieb Carlos Eduardo
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 compte...@gmail.com wrote:
I have mysql 5.1.62
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 ka...@el.net wrote:
hi...
so i have this user in the user table in the mysql db that has all the
privileges but grant. now i need
Correct.
Carlos
On Tue, Jan 31, 2012 at 12:03 AM, kalin m ka...@el.net 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..
On 1/31/12 12:47 AM, Carlos Proal wrote:
Hi,
You have
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 dsto...@shh.org wrote:
Hi Folks,
I'm in need to connect from my SQL 2008R2 (64 bit) server, to my MySQL
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
of that.
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
christoph.bo...@gmail.com 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
-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 seems like
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
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
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
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com 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
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 input please let me
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? It's a better replacement for mytop
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
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
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar aim.prab...@gmail.com 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'
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
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/old-client.html
Hope this helps.
Carlos
--
MySQL General Mailing List
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
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.* TO 'carlos'@'localhost
On Thu, May 27, 2010 at 12:26 PM, win.a win@gmail.com 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
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.
/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 this in the backup list, but that one seems to be pretty dead, so i'll
try my
.
-Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 proper place and
now mysql restart smootly.
Thats it.
Regards,
Carlos
list.
Thank you,
Carlos Andrade
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman vegiv...@tuxera.be wrote:
On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens carlosw...@gmail.com
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
hostname
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
John
I think you can do this way on shell:
mysql -h db_server -u user -pPASSWORD DATABASE -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 table from command
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 information relating to the
MySQL innodb
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 |
On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards
redwa...@logicworks.net 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
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
On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey gto...@ffn.com 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
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.
-
? 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: http://lists.mysql.com/mysql
To unsubscribe
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 contents
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
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 source command
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 should
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 change MySQL default
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
) 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 using
://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
. 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
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/mysql
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 really?
Thanks in advance.
--
Regards
On Wed, Jan 13, 2010 at 1:14 PM, Jim Lyons jlyons4...@gmail.com 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 db.tab limit 1;
Interesting. Would you mind
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 -print0 | xargs -0
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 have lost
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
|
|| | localhost | N |
|| | mail | N |
| carlos | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | localhost | N |
++---+---+-+
I see there are 3 root users
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
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
;
Is 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 Tue, Sep 29, 2009 at 11:36 PM, mos mo...@fastmail.fm 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
On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty mgai...@hotmail.com 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
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 1:11 PM, mos mo...@fastmail.fm 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
On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni claudio.na...@gmail.com 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
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 him, I get the following:
mysql
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 my.cnf
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
On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivannsulli...@cappex.com 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!
UPDATE identities
- SET email=replace
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'm
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: Re: Could
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 against the USB
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
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
really
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
Yup. That was what I was looking for. Thanks!
On Mon, Jul 13, 2009 at 3:27 PM, Rayr...@stilltech.net 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 modifications
) 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
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
, 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
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
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
| 0 |1 | Carlos Williams | |
j...@mdamusic.com car...@ideorlando.org | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@mdamusic.com car...@ideorlando.org | | | NULL
| 0 |1 | Carlos Williams | |
car...@ideorlando.org | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@ideorlando.org | | | NULL | 0 |
2 |
| 3 | 0
On Mon, Jul 6, 2009 at 11:33 AM, Blog Tieng Viet blogtiengv...@yahoo.comwrote:
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
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 Fri, May 15, 2009 at 3:57 PM, Claudio Nanni claudio.na...@gmail.com 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
I noticed today that I strangely was unable to login to MySQL as root.
I just assumed I forgot the password and decided to reset my root
password:
1 - /etc/init.d/mysqld stop
2 - mysqld_safe --skip-grant-tables
3 - mysql -u root
4 - mysql use mysql;
mysql mysql update user set
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 try to log in.
Carlos
On 5/14/2009 5:28 PM, Carlos Williams wrote:
I noticed today that I strangely was unable to login
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal carlos.pr...@gmail.com 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
try to log in.
Thanks for the reply! I
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 at 6:31 PM
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal carlos.pr...@gmail.com 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 checked
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
1 - 100 of 297 matches
Mail list logo