Posts: 3
Threads: 1
Joined: Jun 2018
Reputation:
0
2018-06-09, 05:42 PM
(This post was last modified: 2018-06-09, 05:49 PM by Rikys.)
Sorry about this, but I get an error while creating the tables for MyBB in the installation wizard, and I haven't found any similar error in the forum.
Screen: https://prnt.sc/jt0f0r
MySQL server version is 8.0.11
Can someone help me with this ?
Posts: 1,908
Threads: 80
Joined: Dec 2016
Reputation:
91
2018-06-10, 12:47 PM
(2018-06-09, 05:42 PM)Rikys Wrote: Sorry about this, but I get an error while creating the tables for MyBB in the installation wizard, and I haven't found any similar error in the forum.
Screen: https://prnt.sc/jt0f0r
MySQL server version is 8.0.11
Can someone help me with this?
Don't use MySQL, use MySQLi. It works much better with MySQLi.
I am running MySQLi 5.6.36
I'm Serpius and You're Not ¯\_(ツ)_/¯
Posts: 37,498
Threads: 399
Joined: Apr 2008
Reputation:
776
2018-06-10, 12:57 PM
https://github.com/mybb/mybb/issues/2921
MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.
Posts: 3
Threads: 1
Joined: Jun 2018
Reputation:
0
2018-06-10, 03:01 PM
(2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921
MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.
I have tried but the MySQL server don't start
Posts: 1,908
Threads: 80
Joined: Dec 2016
Reputation:
91
2018-06-10, 03:29 PM
(2018-06-10, 03:01 PM)Rikys Wrote: (2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921
MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.
I have tried but the MySQL server don't start
Please re-read my post #2.
I'm Serpius and You're Not ¯\_(ツ)_/¯
Posts: 3
Threads: 1
Joined: Jun 2018
Reputation:
0
2018-06-10, 03:38 PM
(2018-06-10, 03:29 PM)Serpius Wrote: (2018-06-10, 03:01 PM)Rikys Wrote: (2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921
MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.
I have tried but the MySQL server dont start
Please re-read my post #2.
Sorry but isn 't MySQLi an extension of MySQL?
Posts: 37,498
Threads: 399
Joined: Apr 2008
Reputation:
776
2018-06-11, 09:09 AM
MySQLi is just the PHP driver with MySQL rather than anything to do with MySQL itself, and you'll already be using that as I imagine you'll be using a modern version of PHP which won't even have the old non-i extension installed.
Do you manage the server yourself or do you have a server company run it for you? We wouldn't really be able to help with downgrading MySQL or any issues with it starting.
Posts: 1,908
Threads: 80
Joined: Dec 2016
Reputation:
91
2018-06-11, 02:15 PM
(2018-06-10, 03:38 PM)Rikys Wrote: (2018-06-10, 03:29 PM)Serpius Wrote: (2018-06-10, 03:01 PM)Rikys Wrote: (2018-06-10, 12:57 PM)Matt Wrote: https://github.com/mybb/mybb/issues/2921
MyBB isn't compatible with MySQL 8 yet, if you can, try and use 5.7.
I have tried but the MySQL server dont start
Please re-read my post #2.
Sorry but isn't MySQLi an extension of MySQL?
Yes...
The MySQLi Extension (MySQL Improved) is a relational database driver used in the PHP scripting language to provide an interface with MySQL databases. There are three main API options when considering connecting to a MySQL database server: PHP's MySQL Extension. ... PHP Data Objects (PDO)
However...
You can't mix any of the three ( mysql_* , mysqli_* , PDO ) MYSQL API's from PHP together, it just doesn't work.
It's even in the manual FAQ: It is not possible to mix the extensions.
Go here: MyBB Installation Manual and scroll down to the paragraph 'Database Engine' and it states "If you have the option between MySQL and MySQL Improved, usually the Improved is the better choice."
Just my 2 cents.
I'm Serpius and You're Not ¯\_(ツ)_/¯
|