New MySQL Install Questions

[CTekGirl]

I am setting up MySQL on a server and some things are not very intuitive.

In the WinMySQLAdmin1.4(terminal client) the Environment Window for MyODBC says 'Not Found' for the odbc file although when I looked in the path of WIN20/system32 the dll is there. why is that occurring? I have installed myodbc from mysql.com

I also installed the client MySQL Control Center, I can create servers, but the connection status in the windows says 'NO'. None of the servers I created connect. I am uncertain what ID/PSWD I should be using.

I used the id/pswd from my .ini from MySQL, but it doesnt work and the control center just closes. When I open it again, there is another server, but it doesn't work either.

It appears to connect with a blank pswd/id, but you cannot connect to any installed db, or create a user with any rights.

I have worked with larger RDBMS, but this one is a little different. Any tips or assistance would be appreciated.

 

[CTekGirl]

Anyone?

 

[CTekGirl]

I am still researching these issues while awaiting a response from the forum. What I have found thus far is that there is a bug with the 3.51 version of the ODBC Driver and Win2k.

Meaning that it will continue to state 'Not Found' even when it finds the driver. I found other DBAs using Win2k just ignore this problem, does anyone have any experience regarding this?

In regards to the MYSQL Control Center, it appears that this screen does not refresh automatically. When I manually selected the option to refresh, it does show a connected status.

In regards to the connection problems, I found another program called SQLyog where I was able to create users with full rights to the database and view existing rights of other users. I can now access the User and Server Administration of the MySQL Control Center; previously I could not.

I am posting this information in an effort to help other with the solutions that I have found.

 

[hvass]

Sorry you did not get any response from the forum. I guess as a way of an excuse if others are like me we don't often use the GUI's and don't use them for trouble shooting.

My trusted list of tools are MySQLFront I use for coding speed (although the editor is limited) & testing, phpmyadmin for admin/access to remote servers otherwise use standard mysql client and mysqladmin from the command line.

Reading your post I will continue with my policy of largely staying away from GUI's to administer/run MySQL.

 

[sleipnir214]

I think the real lesson to be learned is to stay away from GUIs that use ODBC to communicate with MySQL. There are a number that run on Win32 and that use native communication libraries, which bypassed any ODBC problems.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[CTekGirl]

I don't know how often open source programs are actually tested to see if it works or how buggy it might be. I am using the GUI client that comes with the install of MySQL. I only reverted to other tools when it appeared to be troublesome. Coming from a background of administering enterprise database systems, I have used GUI and scripted formats. I don't have a real preference I can use both, my goal is just to use something that works. This will not be my primary RDBMS I am just expanding my knowledge base.

In regards to MYODBC I do not believe it is a requirement for MySQL to run, however I wanted to test it using some external reporting tools that use ODBC.

I would like to get input from some individuals that have had positive experience using GUI.

 

[rzs0502]

The MyODBC info in WinMySQLAdmin does not always reflect (Mine says 'Not Found' but does show me the dll info). So don't worry about that.

If you installed the MySQL database on Windows, you can connect as root from any other box. The default password is <blank>. If it is on Linux, you need to logon the the database on the server itself and allow root to logon from other hosts. (Not ideal for security!!!)
ie.
mysql -h localhost -u root -p
(then enter to send blank password)
use mysql
update user set host = '%' where user='root'

This will allow the MySQL Control Centre to be used from any other host. (Rather create a new user for this)

(Don't forget to assign root a password)