RE: Administrator (first screen)

That means that mysql server might is not running, you said that you
installed from yum, have you try to connect trought command line? If so,
have you been able to do it succesfully?

Search in google how to change this file: /var/lib/mysql/mysql.sock because
if you've installed from yum that file mught be in another location, like
/usr/local/mysql/data/mysql.sock

Try searching that file, and specifying to mysql administrator where it
is....

Or you can also google to how specify mysql.sock path...


Regards!


+-------------------------------------+
| ISC Edwin Cruz <[email protected]> | +----+
| System's Manager                    | |    |
| Transportes Medel Rogero SA de CV   | |    |
| Desk: +52 (449) 910 30 90 x3054     | +----+
| Aguascalientes, Mexico              |
| http://www.medel.com.mx             |
+-------------------------------------+



-----Mensaje original-----
De: Ossi Talonpoika [mailto:[email protected]] 
Enviado el: Miércoles, 01 de Febrero de 2006 05:02 a.m.
Para: [email protected]
CC: [email protected]
Asunto: Re: Administrator (first screen)


Hi Thufir!

Good tool for creating tables is MySQL Query Browser. MySQL 
Administrator is mostly for controlling MySQL server, changing its 
configuration and other things server maintenance includes.

Localhost is the computer you are using. Username is MySQL username, not 
your computer username (which you use to login to your computer). If you 
haven't created any user to MySQL, username is 'root' and password is 
empty. With this username and password you can get to MySQL 
Administrator and create more users, set passwords and control their rights.

I don't know Fedora much, but it seems you don't have MySQL running. 
Maybe someone else in this mailinglist could advice you more with that.

You should also check http://dev.mysql.com/doc/ for more information 
about MySQL server and it's tools.

Hope this helps you get going with MySQL. It's really powerfull tool 
when you learn to use it.

--
Ossi Talonpoika
Lapro Software Oy



[email protected] wrote:
> I get the following error:
> 
> 
> Could not connect to host 'localhost'.
> MySQL Error Nr. 2002
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
> 
> Click the 'Ping' button to see if there is a networking problem.
> 
> 
> PING localhost.localdomain (127.0.0.1) 56(84) bytes of data. 64 bytes 
> from localhost.localdomain (127.0.0.1): icmp_seq=0 ttl=64 time=0.156 
> ms 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64
> time=0.125 ms
> 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=2 ttl=64 
> time=0.119 ms
> 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=3 ttl=64 
> time=0.120 ms
> 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=4 ttl=64 
> time=0.119 ms
> 64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=5 ttl=64 
> time=0.116 ms
> 
> 
> 
> 
> Upon entering:
> 
> Server Hostname:        localhost
> Port:                3306
> Username:            thufir
> Password:            <password>
> 
> 
> 
> I'm googling, but not really understanding exactly what Admnistrator
> does. For now, I'd be happy to create single table with a few rows, 
> columns and dummy data!  Username refers to a user on the local 
> machine?  localhost means to use my home computer?  password is the 
> password on the local machine?  Heh, I think I need the idiots guide to 
> MySQL :(
> 
> Pointers?
> 
> I've installed from Fedora, FC4, with yum.  I'm not seeing
> /usr/local/mySQL, for what it's worth.  I'm turning to MySQL because 
> Open Office "Base" doesn't, apparently, offer compound foreign primary 
> keys, aka composite foreign primary keys.  Administrator is the best GUI 
> for making fairly simple databases for MySQL?
> 
> 
> I found this post:
> MySQL Forums :: MySQL Query Browser :: MySQL Error Nr. 2002
> 
>     * Forum List
>     * Search
>     * Français
> 
> MySQL Tools » MySQL Query Browser » MySQL Error Nr. 2002 MySQL Error 
> Nr. 2002 Posted by: Christian Ehm (IP Logged)
> Date: July 7, 2005 03:00AM
> 
> 
> 
> but no reply :(
> 
> 
> 
> 
> 
> Thanks,
> 
> 
> Thufir
> 
> 
> ----------------------------------------------------------------------
> --
> 
> 


-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]



-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]