Win a copy of Programming with Types this week in the Angular and TypeScript forum
or The Design of Web APIs in the Web Services forum!

martin codey

Greenhorn
+ Follow
since Dec 28, 2019
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
1
Given in last 30 days
1
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by martin codey

Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 1005 (HY000) at line 547: Can't create table `mysql`.`db` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 549: Can't create table `mysql`.`global_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 600: Can't create table `mysql`.`roles_mapping` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 601: Can't create table `mysql`.`func` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 602: Can't create table `mysql`.`plugin` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 603: Can't create table `mysql`.`servers` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 604: Can't create table `mysql`.`tables_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 605: Can't create table `mysql`.`columns_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 606: Can't create table `mysql`.`help_topic` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 607: Can't create table `mysql`.`help_category` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 608: Can't create table `mysql`.`help_relation` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 609: Can't create table `mysql`.`help_keyword` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 610: Can't create table `mysql`.`time_zone_name` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 611: Can't create table `mysql`.`time_zone` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 612: Can't create table `mysql`.`time_zone_transition` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 613: Can't create table `mysql`.`time_zone_transition_type` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 614: Can't create table `mysql`.`time_zone_leap_second` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 615: Can't create table `mysql`.`proc` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 616: Can't create table `mysql`.`procs_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 620: Can't create table `mysql`.`general_log` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 624: Can't create table `mysql`.`slow_log` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 626: Can't create table `mysql`.`event` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 665: Can't create table `mysql`.`innodb_table_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 669: Can't create table `mysql`.`innodb_index_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 673: Can't create table `mysql`.`transaction_registry` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 727: Can't create table `mysql`.`proxies_priv` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 733: Can't create table `mysql`.`table_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 734: Can't create table `mysql`.`column_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 735: Can't create table `mysql`.`index_stats` (errno: 13 "Permission denied")
ERROR 1005 (HY000) at line 745: Can't create table `mysql`.`gtid_slave_pos` (errno: 13 "Permission denied")
FATAL ERROR: Upgrade failed
(I took this unanswered question from the internet beacuase it explained my situation very good and I am also using a mac)

I added a user A with only access to one Database 'B'.

If I log in with it in MySQL Workbench, it shows me:

Tables could not be fetched
Views could not be fetched
Stored procedures could not be fetched
Functionscould not be fetched
The fun thing is that under "Tables could not be fetched" all tables of the DB are shown. The query SHOW TABLES; also gives the correct result.

If I log in with the root user or a user with all privileges on . it displays everything correctly.

I have tried the solution mysql mysql_upgrade -u root -p --force and mysql_upgrade -u root -p but i got the errror below.


Everything worked fine with the connection after your help but out of nowhere it stopped working and I don't know why.
When i try connecting to the connection via workbench (look at picture) it only loads and then crashes.
When I go to terminal and type mysql -u root -p it asks for password and then nothing happens look at second picture.
Thank you for the help.


If you read this and struggle as I did maybe these tutorials can help as they helped me:
install mariadb
install homebrew
Step of reseting the password for root
I dont know my root password, I thought about reinstall of mariadb but I can try your way, whats the steps?
Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:
 Access denied for user 'root'@'localhost'

Please:
1 Check that MySQL is running on address localhost
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user root has rights to connect to localhost from your address (MySQL rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.4.10-MariaDB Homebrew
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db     characterset: utf8mb4
Client characterset: utf8
Conn.  characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 11 min 46 sec
I am using mac and I installed Mariadb via  terminal. What are the steps to identify the problem so you can help me easier?
(Not sure what forum to put this in)
I have installed mariadb server and homebrewer via my terminal and now I am trying to connect the database to one of my netbeans projects.
I got this error when I tried the code you gave me." Incompitable types image cannot be converted to ImageIcon".
2 weeks ago
https://medium.com/@ssaurel/learn-to-create-a-snake-game-in-java-c41e3e3b216e
I hope the link works now. Yeah I maybe should find another tutorial.

I also have the same error even with the code you suggested.
3 weeks ago
I am following this tutuorial (https://medium.com/@ssaurel/learn-to-create-a-snake-game-in-java-c41e3e3b216e) and I can not access the pictures on my netbeans 8.2?
3 weeks ago