visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
315 experts, 1193 registered users, 1659 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Databases :: MySql :: Newbie trying to connect to Mysql using Windows 98
By: Squibi U.S.A.  Date: 05/01/2003 00:00:00  English  Points: 50 Status: Answered
Quality : Excellent
I am new to this type of stuff so I will try to explain the best I can. I am on Windows 98 and I am trying to connect to Mysql using my local machine. Instead of going through all the commands through the dos prompt, I have gone into the /bin folder and opened up winmysqladmin.exe for a visual interface. From there, I was able to see my hostname/ip address, my username and password when I originally started the program. I downloaded a couple GUI interfaces to help me with database creation. MysqlCC is one of them. To get to the point though, I put in the information in MysqlCC that I see in winmysqladmin regarding connection information and it won't connect. I don't know if there is something I need to do in the OBDC data sources regarding the mysql driver. I need some help, and I cannot find a step by step instruction of how to get started anywhere using the GUI interfaces.

I am not looking to use this with PHP. If anything, I want to learn how to build databases the non-access way since I have heard doing them through Mysql are more stable. I will eventually integrate the databases with coldfusion (which I am currently learning)

Thanks
S
By: VGR Date: 05/01/2003 05:47:00 English  Type : Comment
first between coldfusion and PHP, there is only more power and more readability (maintanability) in the side of PHP ;-)

then, even if you want to connect through a GUI, try to do this :
-go to the same /bin directory of mysql,
- input "mysql --user=root --password=yourpassword"

it should connect.

if not, you have a problem that the GUI will reflect.

As a suggestion, I also use winmysqsladmin for surveillance of the server, but the mySql console is as good as any GUI for entering commands, especially if it's matter of running a script (source...) and even more especially if you don't intend to use PHP as a front-end ;-)


Last, I don't understand the reference to ODBC : it has nothing to do here.
By: Squibi Date: 05/01/2003 08:15:00 English  Type : Comment
Well, the ODBC thing came up because I had read on the web and in some books how it is used in regards with Microsoft Access. But since I don't know much about this stuff, I can't elaborate on that.

So do I need to go into the bin and open up mysql(with whatever ending it needs to be) and then I will see or I need to do

C:\mysql\bin\"mysql--user=root--password=mypassword"

I don't need to put my username, just root?
By: TheFalklands Date: 07/01/2003 11:38:00 English  Type : Comment
I would first check to make sure you have the right password. You can easily do this from the command line...

C:\mysql\bin> mysql -u root -pmypassword

Make sure you have a password. If you don't need to specify one (if "mysql -u root" works), then I would create one.

mysql> use mysql
mysql> update user set password=Password("newpass");
mysql> exit

C:\mysql\bin> mysqladmin -u root reload

Now you should be able to login with:
mysql -u root -pnewpass

Launch MySQLCC and creat a new entry (File->New)

Your MySQL setting should look like:
Name: mycomputer
host name: localhost
user name: root
password: newpass

MySQLCC is your best bet to do GUI database administration. MySQLCC does not use ODBC. MySQL prodives a C++ API (which is an alternative to ODBC) that MySQLCC uses. Access can communicate with MySQL through ODBC, but I would advise against using Access to do any administration.
By: VGR Date: 08/01/2003 07:15:00 English  Type : Comment
100% agree with the preceding comment.

As for your questions, yes use your own login/password, but as you also have a "root" login in mySql, and an associated password, it's a good idea to check this access too 8-))

I would recommend changing directory to c:\mysql\bin before issuing "mysql --user=youruser --password=yourpassword" because of some possible problems

**you never know*** so also check that the databases files are not read-only (I had this R- attribute silently added to my files while recovering a backup from CD or FTP ;-)

the database's fields are located in the place specified in my.ini, that is "datadir=" I guess

for performance reasons, I usually change the default setting so that they go to a distinct, fast, reliable and easy-to-backup drive 8-)
By: Squibi Date: 08/01/2003 08:07:00 English  Type : Comment
You guys are too fast for me:) I am just learning this stuff, so its hard for me to comprehend some of the stuff you tell me. What confuses me about the password thing is when I first launched Mysql, it brought up a screen that says, please make a username and password. That is what I did regardin the login and password.

How about this. Lets start from scratch. I will uninstall Mysql. and redo this from the beginning so I will be up to speed.

Keep in mind, i have windows 98. What are the steps I should take from INSTALLATION.

Thanks
S.
By: VGR Date: 08/01/2003 19:53:00 English  Type : Answer
no no it's not necessary.

So you entered a login/password during mySql installation ? Hummmm rather strange, no memory of this myself 8-))

you in fact have various users (in the sens of the mySql RDBMS, as for Oracle , DB2 and such) :
- 'root' which is the superuser
- other "logins" like "mysql" sometime, or your name.

If you had to add a complete pair (login,password), then there are chances that you fell into the second case ;-)

Have you been prompted to set up a "root" password ? If no, then it's not set.

Go to the OS console, change dir to C:\mysql\bin

then issue this ***to check***

mysql <return> - you should see an error message
mysql --user=root <return> - you ***may*** be granted access. Then the "root" password is not set. MySql works. Follow the documentation for adding a new user or changing the root password

mysql --user=theuseryoucreated --password=thepasswordyouchose
- you should be granted access at a "normal user" level

if any error arises, please tell me which one and at which stage

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

EContact
browser fav
page generated in 343.119140 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page