Server Mysql Error 1044

JeanXeb

Member
Hello,
When I connect radioboss to my mysql server.
It returns the following message to me :
ERROR 1044 (42000): Access denied for user 'radioboss'@'%' to database 'Test'
All privileges have been granted.
Cordially
 
It means that server does not allow the connection - please make sure the database name is correct and also that a user actually has rights.
 
However all rights are granted  ???

Error message : [2020-03-02 13:58:23] Access denied for user 'radioboss'@'%' to database 'radioboss_test' (1044)
 

Attachments

  • mysql  user.JPG
    mysql user.JPG
    128.5 KB · Views: 368
  • mysql  user2.JPG
    mysql user2.JPG
    72.6 KB · Views: 358
The problem is with database configuration, not with RadioBOSS. It is possible that database does not allow external connections (from other computers), there's also a number of other reasons.
 
I have a new problem now !

Index column size too large. The maximum column size is 767 bytes. (1709)

I deleted the radioboss database but the problem persists

+--------------------------+-----------+
| Variable_name            | Value    |
+--------------------------+-----------+
| innodb_file_format      | Barracuda |
| innodb_file_format_check | ON        |
| innodb_file_format_max  | Barracuda |
| innodb_file_per_table    | ON        |
+--------------------------+-----------+

+---------+---------------+--------------------+--------+
| Charset | Description  | Default collation  | Maxlen |
+---------+---------------+--------------------+--------+
| utf8mb4 | UTF-8 Unicode | utf8mb4_general_ci |      4 |
+---------+---------------+--------------------+--------+

PHP 7.4.1
MySQL Server 5.5.45
 
Minimum required MySQL is 5.7, as described here: https://manual.djsoft.net/radioboss/en/additional-information-storage.htm
 
Is there a client solution to communicate with MySQL remote database ?

Edit Mix point placement      |                      | Studio play mix point
PC client workstation ?        | <  MySQL  >  | Server distant studio
network drive \\vm\music    |                        | network drive \\vm\music 

Is it possible to switch to multiple mysql databases ?
 
You can have multiple RadioBOSS instances installed on different computers that communicate using the same database.
 
Back
Top