Can not manually create a database ( db, user, pass ) for a plugin

As per GentlemanMax’s comment, you’ll want a table.

There’s a really useful guide in the Codex (which also goes into how to do DB upgrades / migrations.)

One thing I’d emphasise: make sure to use $wpdb->prefix in the table name because not all sites will have tables beginning wp_*.

Also, if you’re ever planning to distribute your plugins to other people, remember not every WordPress cloud hosting services will allow their customers to use custom tables (some of the larger ones allow the standard WordPress tables or preapproved plugins only – which is irritating but worth bearing in mind.)

Related Posts:

  1. How to auto login user again after change user_login
  2. How to Join two tables from separate databases within WordPress
  3. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  4. WPDB: how to get the value of a field in a custom database table
  5. How to generate page content from database the right way?
  6. phpMyAdmin displays error when importing database
  7. Transferring working local PHP site to wordpress – with database (MySQL)
  8. Databases – Submitting data from inputs to database [closed]
  9. Is it best to avoid using $wpdb for security issues?
  10. Lost in trying to create user database system
  11. Filter results from a serialized string to use on statistics
  12. wordpress site – using custom database and PHP
  13. add role on WordPress in PHP on a second database
  14. Front end/Database connection in WP
  15. direct query to post_meta table
  16. can’t delete a row from post_meta table
  17. Querying multiple meta_keys in WordPress SQL query
  18. Retrieve data from external database and insert back in
  19. Split reads to a different connection string
  20. custom user role wordpress – grant guest access to edit.php without insert/update/delete
  21. Execute long and heavy processes
  22. Dynamic content in template
  23. database sent to a JSON file
  24. Archive post by meta value + 24hours
  25. inserting a post from an extern php file but post content doesn’t show on wp site
  26. Genesis framework comments broken?
  27. $wpdb->insert() does not Insert record in a table
  28. Using custom tables for old posts
  29. db converts decimal number wrong
  30. Not connecting to database in file with multiple MySQL connections
  31. Filtering a Database Query
  32. Display Data in Table from External Database in WP using Shortcodes
  33. How can I import an excel column into wordpress database?
  34. Blob file download problem
  35. WordPress Block developer from exporting Database via PHP
  36. How to retrieve the data from the sever and displaying it in a page?
  37. Execute a function every hour in the background
  38. Create page with custom php script and fetched data
  39. wpdb prepare insert table doesn’t work
  40. Should I use WordPress to skin a database website?
  41. How do I display offsite database info on my wordpress site?
  42. Creating Database Table vs. Adding MetaData to Post & User
  43. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  44. dynamic page using php from sql database
  45. Building a REST API for your web app exposes primary keys of DB records?
  46. Most commented posts by time period (last 12h, last 24h and etc)
  47. Use $wpdb or other PHP script method to find/replace in WP database
  48. How to Update post_modified of all wordpress post
  49. Correct PHP to output a single result of a Function with SQL Query
  50. How can I add a new row in a separate database when someone registers via WordPress?
  51. Saving data from custom form in wordpress database
  52. How can I find the cause of a 500 server error?
  53. I can’t update my data through $wpdb
  54. wpdb Cannot Update column in Database
  55. Can’t successfully check if post with title exist in database
  56. Cant connect to database with php 7.3
  57. PHP -> SQL Query with Summing
  58. Delete database record using plugin from admin panel
  59. Pull MySQL data from multiple tables and merge into 1 PHP array
  60. How to get image from url from the database?
  61. Set default Database Storage Engine when creating tables with plugins?
  62. Wpdb get->results to out the the month from the db
  63. How to add data to a custom field at the wp_users table?
  64. Creating custom page template from existing PHP site
  65. Searching Posts Programmatically in a WordPress Plugin
  66. Get wp_current_user_id using PHP and MySQL
  67. Use variable in SQL statement
  68. WPDB – Read and write value from / to database
  69. How do I make this Metabox show current DB value?
  70. Why my query does not run with prepare
  71. How to Generate a list of Most Commented post?
  72. Why when I create a new post I found 2 record related to this post into the posts database table?
  73. Adding data to custom wordpress database table
  74. wpdb getting avatars and author url
  75. mySQL queries are executed twice on wordpress website
  76. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  77. Add row to custom database Table and delete all rows older than 1 day
  78. select a single val though a table in wordpress
  79. making php value numeric
  80. Using color schemes with Color Picker
  81. WordPress SQL JOIN query
  82. Fetching review value using wpdb class
  83. Remove password protection from all posts
  84. quotes problem in very simple sql
  85. wordpress sql posts query won’t display the latest post in a specific category
  86. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  87. SQL error with custom query
  88. WP_Query: How to get results from both meta_key options?
  89. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  90. Add posts to custom table in database instead of wp_posts
  91. get_terms with specific id order
  92. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  93. Using PHP Code Snippets to query a database, $dbconnection->get_results is outputting nothing
  94. Tracking Visitor LatLng with WordPress using JS, PHP. How to put data which was extract using JS into DB
  95. Database entry removed on browser refresh, Ajax PHP jQuery
  96. Database SQL query error
  97. get different meta-data of a complicated query at the same time
  98. WordPress SQL Prepare
  99. Please help! I have a problem with getting wordpress databas
  100. Change wordpress’ database data using ajax – how to get current user id?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)