We help IT Professionals succeed at work.

Issue to MySQL

63 Views
Last Modified: 2019-11-27
Hi,
I set up MySQL57 (version 5.7.28), and where can I get same file (in 32-bit) for file below

C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll

How to verify MySQL 5.7.28 is fine, after the setup?
Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
>> I set up MySQL57 (version 5.7.28), and where can I get same file (in 32-bit) for file below

if you wish to have the libmysql.dll from MySQL 5.7.28, then you can download MySQL 5.7.28 from below link, install it in another environment and copy the files from there and replace it out..
https://dev.mysql.com/downloads/mysql/5.7.html

>> How to verify MySQL 5.7.28 is fine, after the setup?

If you meant by whether the installation of MySQL 5.7.28 is fine or not, then you can follow the post installation check list below..
https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html
David FavorFractional CTO
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
You asked, "How to verify MySQL 5.7.28 is fine, after the setup?"

Several options...

1) Use the related mysql command line client, which requires a working MySQL library to work.

2) Write code which interacts with your MySQL library directly.

In either case, you'll just issue a few commands, because the library will either work completely or fail completely, so you'll know on your first database command (like database create, insert, select) if your MySQL library is working.
Peter ChanProblem resolver

Author

Commented:
I take 32-bit mysql-5.7.28-win32 zip file and inside it, I do not see setup.exe. How to set it up?
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
>> I take 32-bit mysql-5.7.28-win32 zip file and inside it

You should download the MSI installer from here.. I believe you downloaded the Archive or binaries instead of MSI installer..
https://dev.mysql.com/downloads/windows/installer/5.7.html
Peter ChanProblem resolver

Author

Commented:
What is problem to error below

6e.png
due to this command?
telnet 127.0.0.1 3306
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Telnet to port 3306 merely means you are testing the socket is open.
You do not have the appropriate way to communicate over telnet.

Download workbench, GUI tools
Or use MySQL.exe to connect to the MySQL server 127.0.0.1 port 3306 with user root and a password you set when installing
Peter ChanProblem resolver

Author

Commented:
Sorry, how to connect to MySQL on port 3306, by running MySQL.exe?
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
On the system,
mysql.exe -u root -p
Drop the -p if you did not set a password.

Get the GUI tools it is easier if you are not comfortable with command line tools.
Peter ChanProblem resolver

Author

Commented:
Here is what I've got
6f.png
how to further check it on port 3306?
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
You are now connected to the MySQL server.
Show databases;
What do you want to do?
Peter ChanProblem resolver

Author

Commented:
I have issue to connect to MySQL DB within hMailserver like
6g.pngI got that reason is due to that the file below is 64-bit. How to resolve it, as I cannot find out file "libmysql.dll" within download file - mysql-5.7.28-win32.zip.?

C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
When you loged in to MySQL using the command MySQL.exe did you use a password?
The error says you tried to login with root@localhost with a password

Did you already setup the database for hmailserver?

Best to setup a separate user that only has access to the hmailserver db

Are you setting up hmailserver again?
Peter ChanProblem resolver

Author

Commented:
Yes, I logon with password.

How to setup the database for hmailserver?

Current hMailserver is on another server, with MySQL inside.
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
one option is to use mysqldump to backup the database there  and then restore it on this one.
another is to use workbench to connect to each server and copy the data from one to the other.
show create database hmailserver
...

much depends on what you want to achieve, you could setup the new one as a slave to the current one.
Using replication
Peter ChanProblem resolver

Author

Commented:
Thanks a lot.
How to resolve issue of 64-bit version of mentioned file?

Here is what I've got:

mysql> show create database hmailserver;
ERROR 1049 (42000): Unknown database 'hmailserver'
Get access with a 7-day free trial.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.