# mysql error and can't get in winmysqladmin

**URL:** <https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034>\
**Category:** Other MySQL® Questions\
**Created:** [December 13, 2008, 12:21am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034 "2008-12-13T00:21:05Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![garyww](https://avatars.discourse-cdn.com/v4/letter/g/48db29/32.png) [@garyww](https://forums.percona.com/u/garyww)\
**Post date:** [December 13, 2008, 12:21am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/1 "2008-12-13T00:21:05Z")

</div>

Dear mysql,  
I downloaded the mysql 6.0. And i can’t go to the winmysqladmin - the  
administration page. how come  
Please help  
I attach the dump screenshot and you can understand  
And there is no host as well, i then wish to setup my database and  
import one database from my webhosting company.  
But there is no interfere such as winmysqladmin for me to do  
Please help

thanks  
mr.wong  
my email: [wwmg&#64;etvigator.com](mailto:wwmg&#64;etvigator.com)

---

<div class="post-metadata">

**Author:** ![januzi](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@januzi](https://forums.percona.com/u/januzi)\
**Post date:** [December 13, 2008, 9:48am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/2 "2008-12-13T09:48:43Z")

</div>

According to the mysql documentation windows one package comes with self installer. Did You get this one ? Or You downloaded self extracting version without installation wizard ?

---

<div class="post-metadata">

**Author:** ![garyww](https://avatars.discourse-cdn.com/v4/letter/g/48db29/32.png) [@garyww](https://forums.percona.com/u/garyww)\
**Post date:** [December 14, 2008, 7:44am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/3 "2008-12-14T07:44:15Z")

</div>

Thanks  
There are three download  
Windows Essentials (x86)  
Windows ZIP/Setup.EXE (x86)  
Without installer (unzip in C:)  
What will be the right one? As you mentioned the one package comes with self installer. Therby, which one should i choose and what is the URL?  
i need a mysqladmin for windows interfere to insert all there the database name, create database, ports, login and password,  
and remote access to MySQL. Please instruct

THANKS  
Mr. jimss

---

<div class="post-metadata">

**Author:** ![januzi](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@januzi](https://forums.percona.com/u/januzi)\
**Post date:** [December 14, 2008, 8:31am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/4 "2008-12-14T08:31:52Z")

</div>

Windows ZIP/Setup.EXE should contain everything that is needed

After installation winmysqladmin will be accessible from windows command line: c:{mysql}\bin\winmysqladmin (where {mysql} is a directory where You installed it). It should be on Your disk right now, so You could look for it. If yes, then all You need to do is run it from windows command line, not from mysql command line. Sometimes winmysqladmin demands proper settings inside my.ini

| [B]Quote:[/B] |
| 

[client]  
password=  
user=

[WinMySQLadmin]  
Server=c:/MYSQL/bin/mysqld.exe  
user=Admin  
password=

 |

This should do the trick (just enter Your mysql root's user name and password)

---

<div class="post-metadata">

**Author:** ![garyww](https://avatars.discourse-cdn.com/v4/letter/g/48db29/32.png) [@garyww](https://forums.percona.com/u/garyww)\
**Post date:** [December 14, 2008, 8:45am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/5 "2008-12-14T08:45:32Z")

</div>

Dear januzi,  
Yes, indeed, i installed the mysql 6.0 with the correct windows ZIP/setup.exe one and installed with from the wizard.  
Then i go to c:\program files\Mysql\bin\winmysqladmin  
I typed this command on the windows and run this winmysqladmin  
with correct path. But nothing show up or display on the screen of my windows 2003  
Should i go to config the my.ini  
Please hints and why it nevers come out with the winmysqladmin  
even I installed success, on the services of the windows, it is running. But nothing show up.

thanks to let me know.  
thanks  
Mr. jimss

---

<div class="post-metadata">

**Author:** ![januzi](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@januzi](https://forums.percona.com/u/januzi)\
**Post date:** [December 15, 2008, 6:52pm UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/6 "2008-12-15T18:52:35Z")

</div>

try to run winmysqladmin from command line, eg:  
start - run - cmd  
You will get:  
c:\documents and settings\blah\blah  
type:

| [B]Quote:[/B] |
| 

cd c:\program files\mysql\bin  
winmysqladmin.exe

 |

(note that program files could be program~1 or something simmilar - You can always type [B]dir[/B] and check directory name)

After You press enter You should see something in console (error message, or at least some kind of message - “Could not run winmysqladmin, … missing” etc). You could also check command

| [B]Quote:[/B] |
| 

winmysqladmin -u root -p

 |

(and like mysql console it should ask for the password)

I think that mysql console could do the same like winmysqladmin, You could use it with:

| [B]Quote:[/B] |
| 

mysql -u root -p \< filename.sql

 |

and everything from filename.sql should get inside database. One problem is that inside filename.sql You should enter 

| [B]Quote:[/B] |
| 

use database\_name ;

 |

or add -D database (or it was -d database ?) {windows applications should print their help with command [B]application.exe /?[/B]} 

And for the databases, You could create them from mysql console.

---

<div class="post-metadata">

**Author:** ![garyww](https://avatars.discourse-cdn.com/v4/letter/g/48db29/32.png) [@garyww](https://forums.percona.com/u/garyww)\
**Post date:** [December 15, 2008, 8:08pm UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/7 "2008-12-15T20:08:00Z")

</div>

Thanks for your prompt reply. I finally download the MySQL Administrator  
Then i go to new connection. Just have a simply question, if i want to host  
everything included database and webstore.

I can see the connections \> new connection

1. What will be the parameter for ‘stored connection’?
2. For ‘Server Host’, is this just simply the computer name as well?
3. For username and password, is it just same as the MySQL wizard after i click  
the setup.exe of Windows ZIP/setup.exe let say MySQL 5.1 as well?
4. If i want to create a database name ie. qgame-qdb  
and the database that is already existed in my current webhosting company, i  
then export the database and how it import back the MySQL 5.1 through the MySQL  
Administrator User Interfere?

Please instruct.  
Please help

thanks

---

<div class="post-metadata">

**Author:** ![januzi](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@januzi](https://forums.percona.com/u/januzi)\
**Post date:** [December 16, 2008, 6:58am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/8 "2008-12-16T06:58:52Z")

</div>

1. no idea
2. localhost or host name connected to Your ip (127.0.0.1 =\> localhost)
3. yes, but You should add few users with less privileges (connected to specific databases)
4. never did that

---

<div class="post-metadata">

**Author:** ![garyww](https://avatars.discourse-cdn.com/v4/letter/g/48db29/32.png) [@garyww](https://forums.percona.com/u/garyww)\
**Post date:** [December 21, 2008, 5:51am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/9 "2008-12-21T05:51:51Z")

</div>

Dear all,  
How are you? merry x’mas? I do installed the gui format of winmysqladmin,  
it allowed me to have new connection host name and username password, i get it  
and click on the restore on the mysql admin  
I tried to restore from the .sql file but can’t success and unable to retrieve  
based on os commerce \>admin\>backups\>xxx.sql file. How about if i go to  
Ensim pro of lunix one to export the database of sql file and restore at  
winmysqladmin. Might it able to do it like this to retrieve the database  
successfully

thanks to let me know

gary

---

<div class="post-metadata">

**Author:** ![januzi](https://avatars.discourse-cdn.com/v4/letter/j/82dd89/32.png) [@januzi](https://forums.percona.com/u/januzi)\
**Post date:** [December 21, 2008, 9:46am UTC](https://forums.percona.com/t/mysql-error-and-cant-get-in-winmysqladmin/1034/10 "2008-12-21T09:46:58Z")

</div>

You could use mysql.exe to import tables

| [B]Quote:[/B] |
| 

mysql -u nick -p \< file.sql

 |

(mysql will ask You for password)

You should see errors (if any) or after a while you will see c:\mysql\bin\ (it will mean that everything went ok)