469,625 Members | 1,080 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Winmysqladmin?

I'm running mysql 4.0.20 on windows 2000. What is the purpose of
winmysqladmin? If I type it, a window opens, then closes, and puts an
stoplight icon on the taskbar. If I click on "show me" it opens the
window again. Then if I click on the databases tab it shows a database
called "test", but none of the others that I can see from the mysql
prompt when logged in as root.

If I type "winmysqladmin -u root -p", the computer starts using 100%
cpu and responds very slowly. So far, I don't see the point of
winmysqladmin. What good is it? Why does it take up all of the cpu if
I try to get into it as the root user?

thanks,
Charles
Jul 20 '05 #1
3 6990
"Charles Selby" <ch***********@yahoo.com> wrote in message
I'm running mysql 4.0.20 on windows 2000. What is the purpose of
winmysqladmin? If I type it, a window opens, then closes, and puts an
stoplight icon on the taskbar. If I click on "show me" it opens the
window again. Then if I click on the databases tab it shows a database
called "test", but none of the others that I can see from the mysql
prompt when logged in as root.
In general, this is a useful tool for administering the database. I've gone
to the Server tab to see the current environment variables. For example,
everytime we start a connection to the database, the Threads_connected
variable increases by one. In the my.ini Setup tab you can modify the
startup parameters, such as your install directory and username to log in
when you start winmysqladmin. As for the database tab not showing your
databases, I find that too on my database, and it looks like a bug.

A really nice graphical tool to install is MySQL Control Center, available
at www.mysql.com.
If I type "winmysqladmin -u root -p", the computer starts using 100%
cpu and responds very slowly. So far, I don't see the point of
winmysqladmin. What good is it? Why does it take up all of the cpu if
I try to get into it as the root user?


It should consume most of your CPU for just a few seconds while it starts
up. Then it should not be noticeable any more. Is this not what you see?
Jul 20 '05 #2
Ken
I use winmysqladmin on Windows 2000. It has very little value to me also.

I use this program to look at my database and change/add items such as user,
etc.
DBManager Professional - freeware ( prosetup220EN.exe)
Then if I click on the databases tab it shows a database
called "test", but none of the others that I can see from the mysql
prompt when logged in as root as a user id without a password.
Ken

Try changing the server to:
odbc@localhost or
mysql@localhost
It worked for me.

If it displays access denied, try using root as the user id without a
password.

Look under c:\mysql\data The folders in the data folder are your databases.

Ken

"Charles Selby" <ch***********@yahoo.com> wrote in message
news:1u********************************@4ax.com... I'm running mysql 4.0.20 on windows 2000. What is the purpose of
winmysqladmin? If I type it, a window opens, then closes, and puts an
stoplight icon on the taskbar. If I click on "show me" it opens the
window again. Then if I click on the databases tab it shows a database
called "test", but none of the others that I can see from the mysql
prompt when logged in as root.

If I type "winmysqladmin -u root -p", the computer starts using 100%
cpu and responds very slowly. So far, I don't see the point of
winmysqladmin. What good is it? Why does it take up all of the cpu if
I try to get into it as the root user?

thanks,
Charles

Jul 20 '05 #3
Ken
I use winmysqladmin on Windows 2000. It has very little value to me also.

I use this program to look at my database and change/add items such as user,
etc.
DBManager Professional - freeware ( prosetup220EN.exe)
Then if I click on the databases tab it shows a database
called "test", but none of the others that I can see from the mysql
prompt when logged in as root as a user id without a password.
Ken

Try changing the server to:
odbc@localhost or
mysql@localhost
It worked for me.

If it displays access denied, try using root as the user id without a
password.

Look under c:\mysql\data The folders in the data folder are your databases.

Ken

"Charles Selby" <ch***********@yahoo.com> wrote in message
news:1u********************************@4ax.com... I'm running mysql 4.0.20 on windows 2000. What is the purpose of
winmysqladmin? If I type it, a window opens, then closes, and puts an
stoplight icon on the taskbar. If I click on "show me" it opens the
window again. Then if I click on the databases tab it shows a database
called "test", but none of the others that I can see from the mysql
prompt when logged in as root.

If I type "winmysqladmin -u root -p", the computer starts using 100%
cpu and responds very slowly. So far, I don't see the point of
winmysqladmin. What good is it? Why does it take up all of the cpu if
I try to get into it as the root user?

thanks,
Charles

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Kyle Goetz | last post: by
reply views Thread by David G. | last post: by
reply views Thread by Fouad El Sioufy | last post: by
22 posts views Thread by Duncan Jones | last post: by
1 post views Thread by Dick Watson | last post: by
reply views Thread by Brad Waddell | last post: by
reply views Thread by fritz | last post: by
1 post views Thread by Charles Selby | last post: by
5 posts views Thread by Kurt Bjernemose | last post: by
1 post views Thread by thecoolone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.