edflecko

The site isn’t externally available yet. It was hosted by GoDaddy, but it’s being migrated to our own data center, on our local LAN.

Ed

I have a syntax error and can’t quite put my finger on it.

GRANT ALL on wpdatabase.* to ‘wpuser’@’localhost’ identified by ‘Rt\HEZ-h,N’;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘identified by ‘Rt\HEZ-h,N’

The version of MySQL I’m running is: 8.0.19

Ed

Thank you!

Since this web-server will, eventually, be serving more than one website, can you guide me on creating the necessary vhost entries? For example, should I create one file for all of the vhost entries, or is the CentOS, Apache default (/etc/httpd/conf/httpd.conf) where I should be creating the vhost entries?

Does this look correct?

<VirtualHost *:80>
  DocumentRoot /var/www/html/
  ServerName mynewwebsite.org
  ServerAlias www.mynewwebsite.org
  ErrorLog /var/log/httpd/mynewwebsite-error-log
  CustomLog /var/log/httpd/mynewwebsite-log common
</VirtualHost>

Ed

• This reply was modified 4 years, 10 months ago by Steven Stern (sterndata).