New answers tagged

2

If your column date_ordered is of type DATE, MySQL will store it in its own way. To display it in the format you want, you should use the function date_format(): https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format e.g. For DD-MM-YYYY format, you want to use the format string '%d-%m-%Y' select date_format (...


0

Yes, it's correct, although, as noticed by yourself , it's pretty crude. This has been asked months ago. Why didn't anyone answer it yet? Are you still working on this project? I wonder if you really have the right skills to complete this... If it's indeed interesting, I could help you with the database architecture. One word of advice: MySQL does not ...


0

If you installed MySQL as a service, you need the following: STEP 01 Open Windows Command Line as Administrator and run C:\> net stop mysql STEP 02 Add this to C:\Program Files (x86)\MySQL\MySQL 5.7\my.ini under the [mysqld] group header [mysqld] skip-grant-tables STEP 03 C:\> net start mysql C:\> mysql You should be logged into mysql ...


0

Are these IP addresses? Then use INT UNSIGNED. It stays 4 bytes like you have (instead of 8 bytes for BIGINT) and is big enough for the old IPv4 ip addresses.


-1

As mentioned in comment Try to ping the server If you have another MySQL client/server try this: mysql -h XXX.XXX.X.XX(your IP) -u root -p Check privileges for root user; you can always do this GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpass' WITH GRANT OPTION; FLUSH PRIVILEGES; If you are using firewall, check iptables These are ...


0

The issue had nothing to do with MySQL parts. It turned out that Linux's firewall and Selinux were blocking access from outside the server. Once turned off, the connection worked perfectly. Two things I learned from this: 1) Check better the ENVIRONMENT before blaming the product, 2) MySQL could improve the clarity of the messages and include environment ...



Top 50 recent answers are included