Can’t create test file lower test start server mysql

I’m following this tutorial here on creating a JDBC programming. I’ve followed the steps up to the console command to start the server:

// For Windows

cd {path-to-mysql-bin}   // Check your MySQL installed directory
mysqld --console

I get the following error message:

mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.7\data\' (Errcode: 2 - No such file or directory)
2017-01-06T10:54:36.968210Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-06T10:54:36.968210Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-01-06T10:54:36.968210Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 11248 ...
2017-01-06T10:54:36.974226Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\DESKTOP-DEQ2IC2.lower-test
2017-01-06T10:54:36.975229Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\DESKTOP-DEQ2IC2.lower-test
2017-01-06T10:54:36.975229Z 0 [ERROR] failed to set datadir to C:\Program Files\MySQL\MySQL Server 5.7\data\
2017-01-06T10:54:36.976231Z 0 [ERROR] Aborting

2017-01-06T10:54:36.977234Z 0 [Note] Binlog end
2017-01-06T10:54:36.978237Z 0 [Note] mysqld: Shutdown complete

I’m quite new to using MySql in this way but I can see that there is no data folder in the server directory and no my.ini file which I assumes holds the config information on where the data directory is. I’ve also insntalled MySql using the windows installer which I’ve read could be why there is no my.ini file and just a template my-default.ini file.

Does anyone know why this is happening?

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  3. MySQL Error “Operand should contain 1 column”
  4. How to use MySQL DECIMAL?
  5. MySQL ERROR 1290 (HY000) –secure-file-priv option
  6. MySQL server startup error ‘The server quit without updating PID file’
  7. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  8. MySQL DROP all tables, ignoring foreign keys
  9. Duplicating a MySQL table, indices, and data
  10. mysql Foreign key constraint is incorrectly formed error
  11. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  12. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  13. mysql is not recognised as an internal or external command,operable program or batch
  14. SELECT * FROM multiple tables. MySQL
  15. mysql: SOURCE error 2?
  16. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  17. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  18. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  19. Data truncated for column?
  20. MySQL foreach loop
  21. MySQL IF NOT NULL, then display 1, else display 0
  22. MySQL date format DD/MM/YYYY select query?
  23. MySQL Calculate Percentage
  24. Repair all tables in one go
  25. Error: select command denied to user ‘‘@’‘ for table ‘‘
  26. Get the new record primary key ID from MySQL insert query?
  27. How to change collation of database, table, column?
  28. Failed building wheel for mysql-python
  29. MySQL Error 1215: Cannot add foreign key constraint
  30. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  31. How to unblock with mysqladmin flush hosts
  32. Node.js MySQL – Error: connect ECONNREFUSED
  33. How to use the keyword ‘references’ in MySQL?
  34. select * from table where column = something or, when unavailable, column = something else
  35. Differences between utf8 and latin1
  36. There can be only one auto column
  37. MySQL – UPDATE query with LIMIT
  38. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  39. What are the recommended database permissions for WordPress?
  40. What’s a good strategy for planning WordPress DB growth?
  41. How can I find the source of slow queries in WordPress?
  42. $wpdb and MySQL Create Trigger
  43. how to refresh wordpress permalink settings? (without admin panel)
  44. Ordering posts by day (not time) AND meta value
  45. Problems with DBDelta with FOREIGN key?
  46. Fulltext search in posts sorted by relevancy
  47. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  48. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  49. How can I make wordpress suppress mysql errors?
  50. How to bulk delete all WordPress subscribers?
  51. Error while importing database
  52. Changing Table Prefix for an Existing WordPresss Site
  53. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  54. Connect another DB and fetch records from some tables
  55. Can I restart MySQL engine when WordPress website is live?
  56. Error: MySQL shutdown unexpectedly [closed]
  57. #1115 – Unknown character set: ‘utf8mb4’
  58. Why my wordpress loopback traffic while socket is setup?
  59. Update or insert meta key value – On Duplicate key update
  60. Connect to MySQL using Windows Authentication
  61. Defining the same price to all WooCommerce Products
  62. Database Structure on Different Servers
  63. Changing MySQL password via WHM – does this affect WordPress?
  64. How to get INSERT errors from $wpdb?
  65. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  66. Export Yoast Keywords from MySQL/phpMyAdmin
  67. Same database; different WordPress
  68. Create pages from MySQL database
  69. How to insert dash (-) into database using wpdb and new_to_publish hook?
  70. MySQL: How to change url in posts from xxx.com to yyy.org?
  71. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  72. Upgrade DB Loop – WordPress DB Version Conflict
  73. WordPress & MySQL , problem with use many array in meta_query
  74. Button writing to MYSQL database
  75. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  76. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  77. MySQL ‘duplicate entry’ error
  78. WordPress Dutch characters encoding problem
  79. How to show result of sql query in a page?
  80. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  81. 403 Forbidden home on localhost with nginx server
  82. How do I insert content of various MySQL fields in post?
  83. Select latest 2 articles, but only from given category
  84. CONCAT_WS in custom sql query
  85. Query does not filter duplicate _sku numbers
  86. Ordering topics by most replies in X days using MYSQL statement
  87. MySQL Select within WP Page template
  88. wp_postmeta – lot of meta fields
  89. Running WordPress from MySQL Cluster with HAPRoxy
  90. Delete posts with word count less than x number of words
  91. MySQL: get post_tag items that are tags (not SEO keywords)
  92. $wpdb->get_var returns 0
  93. cannot log in to the mysql server (wamp and wordpress)
  94. SQL command to export post_content from wp_posts using phpMyAdmin
  95. remove wordpress post links
  96. SQL get last entry of a specific gravity form
  97. mysqldump to a tar.gz
  98. Postgres equivalent to MySQL’s \G?
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?

Leave a Comment

tech