Solved Mysql problem's MySQL 5.7 or 5.6

philo_neo

philo_neo

Hi,
I've bi-quad cores with FreeBSD 10.2, portsnap ok !
After make install on the ports /usr/ports/databases/ :
1/ Mysql 5.7 is ask how to after make reinstall
this is the output:
Code: 
root@dct-pluton:/usr/ports/databases/mysql57-client # make deinstall
===>  Deinstalling for mysql57-client
===>  mysql57-client not installed, skipping
root@dct-pluton:/usr/ports/databases/mysql57-client # cd ..
root@dct-pluton:/usr/ports/databases # cd mysql57-server
root@dct-pluton:/usr/ports/databases/mysql57-server # make reinstall
===>  mysql57-server-5.7.10_3 cannot install: MySQL versions mismatch:
mysql56-client is installed and wanted version is mysql57-client.
*** Error code 1

Stop.
make: stopped in /usr/ports/databases/mysql57-server
root@dct-pluton:/usr/ports/databases/mysql57-server #

i'm not sure but it's about mysql57-client == i'm do a make deinstall

2/ Mysql 5.6 are compile server and client : but Mysql doesn't work
i tape make deinstall server and client !



Now can do for get around Mysql 5 . 7

Regards
Philippe
 
Hi,
I've installed MySQL 5.7, it's started, but i I do the command : mysql -u root I've issue.
When I do the command set family I've this issue :
Code: 
ERROR 1133 (42000): Can't find any matching row in the user table.
This is my output :
Code: 
root@dct-pluton:/usr/ports/databases/mysql57-client # /usr/local/etc/rc.d/mysql-server restart
Stopping mysql.
Waiting for PIDS: 17183.
Starting mysql.
root@dct-pluton:/usr/ports/databases/mysql57-client # mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.10 Source distribution

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('toor');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('toor');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql>

I don't know which database used by default for example ?

Regards
Philippe
 
The initial setup is probably screwed up now. Start fresh:
Code: 
service mysql-server stop
rm -rf /var/db/mysql/*
service mysql-server start
 
You must log in or register to reply here.
Back
Top