MySQL Server Access

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?
LVL 7
rgranlundAsked:
Who is Participating?
 
arnoldCommented:
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
 
Dave BaldwinFixer of ProblemsCommented:
'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
 
rgranlundAuthor Commented:
How do I write this line:
C:>sudo chaown -R mysql:mysql /var/lib/mysql
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Dave BaldwinFixer of ProblemsCommented:
You don't.  It won't work on Windows.
0
 
arnoldCommented:
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
 
rgranlundAuthor Commented:
How do I fix this problem
0
 
arnoldCommented:
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
 
rgranlundAuthor Commented:
The server is in the cloud.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.