• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

Problem in Installing MYSQL:

I downloaded "mysql-essential-5.0.21-win32" from the site "http://dev.mysql.com/downloads/mysql/5.0.html"

Now, I installed it.. But, in the programs menu - I only have: MySQL -> MySQL Server 5.0 -> MySQL Command line Client and MYSQL Server Instance Cofig Wizard

I do not have the WinMySQLAdmin... am I missing something.. did I download the wrong one.. help me out here guys...

Thanks
0
neonlights
Asked:
neonlights
  • 9
  • 5
1 Solution
 
Yuval_ShohatCommented:
unlike previous version, mysql 5 does not come with mysqlwinadmin....
you can read it here:
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-7.html

just start to work.
if you need some administrative tool check this out:
http://dev.mysql.com/downloads/administrator/1.1.html

-=Yuval=-
0
 
ellandrdCommented:
Download and install the mysql administrator separate from mysql 5.

http://www.mysql.com/products/tools/administrator/

then your set to fire again!
0
 
neonlightsAuthor Commented:
Hi Ellandrd,

Thanks for your link;

I installed it.. no problem.. have a one problem.. i am in the MySQL Administration  - Connect to the MySQL Server Instance.

serverhost: localhost
username: (forgot) - I gave a name.. but, forgot it..
password: (have it)

how do I find the username?

thanks again
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
ellandrdCommented:
ok you can use either "odbc" or "root".

if they do not work, run mysql instance manager and create a new one. this is create a clean service, character set, username, password, etc etc

you can check the current user by following these steps:

1) start > run > type "cmd" or "command" (WinNT).
2) once in DOS, browse to your mysql directory.
3) once in your mysql directory, type "dir" and you should get a directory listing.  this listing should contains all files/folders inside your mysql folder.  
4) next type "cd bin" which will bring you into the binary folder.
5) next type "mysql" which will bring you into mysql server it self. you should get a welcome message from mysql server!
6) type "status" followed by ";" so together is looks like "status;". this will show the current status of your mysql server.

look and see who the current user is.  it should be either root or odbc or the username you added when installing...

then when you have this info, try using mysql administrator again...

ive created a few screen shots for you to follow if your get into trouble...

http://www.seandelaney.co.uk/ee/mysql.doc

let me know if you need more help...

Ellandrd
0
 
ellandrdCommented:
also you can view all the user accounts too by following these steps:

after step 6 above.

type "show databases" this will list all the databases in your mysql server.
then type "use mysql" i think that is the default one created and this is the one that holds all your information.

next type "show tables" as this will list all the tables.

check if there is a table called "users". if so then type "select * from users" adn this will list all the accounts created in mysql server.

again as i said if still in doubt or in trouble carrying out these step please contact me...

Ellandrd
0
 
ellandrdCommented:
>>if they do not work, run mysql instance manager and create a new one. this is create a clean service, character set, >>username, password, etc etc

sorry didnt explain that very clear - look at this diagram:

http://www.seandelaney.co.uk/ee/MySQLIntanceConfig.bmp
0
 
neonlightsAuthor Commented:
Hi Ellandrd,

Wow - thanks - worked.

"type "status" followed by ";" so together is looks like "status;". this will show the current status of your mysql server."

worked pretty good - gave me the user name : root@localhost.

One question for you.. why my zonelab is saying that 1) mysql is trying access trusted zone.. and then, 2) mysql is trying access the internet..

normal?

Thanks again for your help. I am my MySQL administrator is working fine.

0
 
ellandrdCommented:
mysql is server and yes these are normal as i see it reported in my firewall too...  i did use zonelabs a few years ago, and i remember mysql using TCP/IP port 3306 which would show up on the firewall logs...
0
 
ellandrdCommented:
remember your firewall is keeping an eye on the ports and mysql is using the port 3306 for TCP /IP hence why is is shown up on your zonelabs....
0
 
neonlightsAuthor Commented:
Thanks again.. but, can anyone use that port to come in?

0
 
ellandrdCommented:
its only for mysql - its only configured for mysql - if you try to get in other than that you will get access denied
0
 
ellandrdCommented:
neonlights

are you still not 100% on it? like are you still no sure?

if you have any more question, fire away, just dont forget bout this question...
0
 
neonlightsAuthor Commented:
Hi Ellandrd,

Perfect.. everything is cool -  I was stuck with Apache installation.. thanks again for your help..

cheers!!!
0
 
ellandrdCommented:
no thank you! especially for the grade A...

;-)
0
 
neonlightsAuthor Commented:
No.. .thank you . lol -

bye...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 9
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now