Busqueda sobre Linux y software libre

Noticias sobre linux y software libre - Google 

MySQL - workbench no se conecta en Ubuntu

Pregunta


Les comento que estoy probando mysql-workbench

-instale una version para ubuntu 10.04 el cual no me funciono
-compilé y vuelvo a intentar conectarme a mysql pero nada y me sale el
siguiente error:

Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at
127.0.0.1:3306:
  Access denied for user 'root'@'localhost' (using password: YES)

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but
this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address
(mysql rights define what clients can connect to the server and from which
machines)
4 Make sure you are both providing a password if needed and using the
correct password for 127.0.0.1 connecting from the host address you're
connecting from

he probado los siguientes:
netstat -tanp |grep 3306
sudo ps -eF | grep mysql
mysqladmin -u root -p version
dpkg -l |grep mysql

al parecer tengo las versiones adecuadas
puedo conectarme desde mysql-administrator y query-browser
y la pregunta es donde configuro que clientes se pueden conectar a mysql?

lo que sigue es las salidas de los comandos ejecutados:
---------------------------------------------------------------------------------------------------------------------------------
netstat -tanp |grep 3306

mysqladmin -u root -p version
Enter password:
mysqladmin  Ver 8.42 Distrib 5.1.49, for debian-linux-gnu on i486
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version        5.1.49-3
Protocol version    10
Connection        Localhost via UNIX socket
UNIX socket        /var/run/mysqld/mysqld.sock
Uptime:            1 hour 6 min 26 sec

Threads: 2  Questions: 579  Slow queries: 0  Opens: 59  Flush tables: 1
Open tables: 51  Queries per second avg: 0.145

sudo ps -eF | grep mysql
[sudo] password for ghaspaer:
root      2111     1  0   437   544   0 17:19 ?        00:00:00 /bin/sh
/usr/bin/mysqld_safe
mysql     2270  2111  0 34439 18900   1 17:19 ?        00:00:01
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
--port=3306
root      2271  2111  0   418   540   0 17:19 ?        00:00:00 logger -t
mysqld -p daemon.error
ghaspaer  3489     1  0  1100  1236   0 17:28 ?        00:00:00 /bin/bash
/usr/local/bin/mysql-workbench
ghaspaer  3493  3489  0   437   516   1 17:28 ?        00:00:00 /bin/sh
/usr/bin/catchsegv /usr/local/bin/mysql-workbench-bin
ghaspaer  3495  3493  1 57905 70396   0 17:28 ?        00:00:51
/usr/local/bin/mysql-workbench-bin
ghaspaer  3555  3074  0   447   540   1 17:30 pts/1    00:00:00 /bin/sh
/home/ghaspaer/.mysql/workbench/delme.KOQEe1
ghaspaer  3592  3557  0  2109  2988   1 17:30 pts/1    00:00:00 mysql -u
root -p
ghaspaer  4659  4162  0   899   832   0 18:26 pts/2    00:00:00 grep mysql

mysqladmin -u root -p version
Enter password:
mysqladmin  Ver 8.42 Distrib 5.1.49, for debian-linux-gnu on i486
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version        5.1.49-3
Protocol version    10
Connection        Localhost via UNIX socket
UNIX socket        /var/run/mysqld/mysqld.sock
Uptime:            1 hour 7 min 48 sec

Threads: 2  Questions: 580  Slow queries: 0  Opens: 59  Flush tables: 1
Open tables: 51  Queries per second avg: 0.142

dpkg -l |grep mysql
ii  gambas2-gb-db-mysql
2.21.0-2                               The MySQL driver for the Gambas
database component
ii  libdbd-mysql-perl
4.016-1                                Perl5 database interface to the
MySQL database
ii  libmysqlclient-dev
5.1.49-3                               MySQL database development files
ii  libmysqlclient16
5.1.49-3                               MySQL database client library
ii  libqt4-sql-mysql
4:4.6.3-4+squeeze1                     Qt 4 MySQL database driver
ii  mysql-admin
5.0r14+openSUSE-2.1                    GUI tool for intuitive MySQL
administration
ii  mysql-client
5.1.49-3                               MySQL database client (metapackage
depending on the latest version)
ii  mysql-client-5.1
5.1.49-3                               MySQL database client binaries
ii  mysql-common
5.1.49-3                               MySQL database common files, e.g.
/etc/mysql/my.cnf
ii  mysql-gui-tools-common
5.0r14+openSUSE-2.1                    Architecture independent files for
MySQL GUI Tools
ii  mysql-navigator
1.4.2-12+b1                            GUI client program for MySQL
database server
ii  mysql-query-browser
5.0r14+openSUSE-2.1                    Official GUI tool to query MySQL
database
ii  mysql-server
5.1.49-3                               MySQL database server (metapackage
depending on the latest version)
ii  mysql-server-5.1
5.1.49-3                               MySQL database server binaries and
system database setup
ii  mysql-server-core-5.1
5.1.49-3                               MySQL database server binaries
ii  php5-mysql


Respuesta

Te esta pidiendo contrasena del root


Otra respuesta

Mysql suele bloquear por defecto las conexiones externas.
Prueba comentado "skip-networking" en el archivo my.cnf

Ads by CJ - Linux Foundation

Share This