Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MySQL Server Access

Posted on 2015-01-17
8
Medium Priority
?
300 Views
Last Modified: 2015-01-24
I have a Windows 2008 Server in a Cloud.  I am having issues connecting to the MySQL Server.
When I run the following from the Comand Line:
C:>"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld"

I get the following Error:
150117 22:05:55 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.5\data\azwebdev02.lower-test
150117 22:05:55 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.5\data\azwebdev02.lower-test
150117 22:05:55 [Note] Plugin 'FEDERATED' is disabled.
150117 22:05:55 InnoDB: The InnoDB memory heap is disabled
150117 22:05:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150117 22:05:55 InnoDB: Compressed tables use zlib 1.2.3
150117 22:05:55 InnoDB: Initializing buffer pool, size = 128.0M
150117 22:05:55 InnoDB: Completed initialization of buffer pool
150117 22:05:55  InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

I read to fix this issue I need to run the follow line:
C:>sudo chaown -R mysql:mysql /var/lib/mysql

I get this error:
'sudo' is not recognized as an internal or external command,
operable program or batch file.

If I run it this way:
C:>"sudo chown -R mysql:mysql /var/lib/mysql"

I get this error:
The filename, directory name, or volume label syntax is incorrect.

Can anyone shed any light on what I am doing wrong?  Do I have the correct Directory name?  Is my Syntaxt Correct?
0
Comment
Question by:rgranlund
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 40555834
'mysqld' is the Service that responds to request for the MySQL server.  It is Not the command line program to access the server.  That is just 'mysql.exe'.

'sudo' is not recognized as an internal or external command,
operable program or batch file.
Of course you do.  'sudo' only works on Linux or Unix, not Windows.
0
 
LVL 7

Author Comment

by:rgranlund
ID: 40555837
How do I write this line:
C:>sudo chaown -R mysql:mysql /var/lib/mysql
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 40555839
You don't.  It won't work on Windows.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 80

Expert Comment

by:arnold
ID: 40555842
you do not the commands you list are unix/linux related not windows.  You use the properties of the directory and add security, though I do not believe it is necessary.
open services and see if you have a mysql server reference.

It was pointed out if you do not have the workbench GUI install which include the GUI administrator for mysql.

command line you would run mysql -u root -p if you set a root password, if you did not run mysql -u root
and you should be on the mysql server.
show databases; should list all your databases.

I think it is possible, though did not try isntalling/running mysql under cygwin.

presumably you downloaded mysql-server.msi from mysql.com and you installed it directly on windows.
0
 
LVL 7

Author Comment

by:rgranlund
ID: 40555847
How do I fix this problem
0
 
LVL 80

Expert Comment

by:arnold
ID: 40555851
it is not clear to me what your issue is?

it was pointed out when you run mysqld you are trying to start the service

look in services,
rerun the mysql configuration tool.
double check where you place the data directory.

Is the mysql running on this server, or you have a mysql server in the cloud?

mysql -u username -p -h ipaddress_of_mysql_server
0
 
LVL 7

Author Comment

by:rgranlund
ID: 40555866
The server is in the cloud.
0
 
LVL 80

Accepted Solution

by:
arnold earned 2000 total points
ID: 40555871
i understand you have 2008 server in the cloud. on this server you installed mysql.
you are seemingly trying to start mysql server directly  (mysqld) versus the services.msc mysql server which might be running already using the credentials if ant specified during the configuration tool.

please try using the services.msc to check whether there is mysql server listed there and if so what is it set manual, automatic, automatic delayed, disabled and is it started?

what happens if you run mysql -u root -h localhost?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question