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]