Difference between revisions of "Talk:MySQL"

From ArchWiki
Jump to: navigation, search
(Change "mysqld.service" -> "mysqld")
Line 1: Line 1:
Two things that might be worth mentioning:
+
== MySQL depricated pass prefix ==
 +
When trying to import any database using mysql command or phpMyAdmin, I get this error:
 +
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Warning: Using unique option prefix pass instead of password is deprecated and w' at line 1
 +
 
 +
== Two things that might be worth mentioning: ==
 
Password for DB root is limited to 79 characters (I was not aware of that as my password policy for databases was 80 characters after setting password I could not log in)
 
Password for DB root is limited to 79 characters (I was not aware of that as my password policy for databases was 80 characters after setting password I could not log in)
 
If the one decides to reset the password then after everything is done but before loading services it might be worth killing mysql. I have done it simple way:
 
If the one decides to reset the password then after everything is done but before loading services it might be worth killing mysql. I have done it simple way:
Line 7: Line 11:
 
[[User:Gregosky|Gregosky]] ([[User talk:Gregosky|talk]]) 23:43, 29 August 2013 (UTC)
 
[[User:Gregosky|Gregosky]] ([[User talk:Gregosky|talk]]) 23:43, 29 August 2013 (UTC)
 
Gregosky
 
Gregosky
 
== MySQL depricated pass prefix ==
 
When trying to import any database using mysql command or phpMyAdmin, I get this error:
 
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Warning: Using unique option prefix pass instead of password is deprecated and w' at line 1
 
  
 
== Change "mysqld.service" -> "mysqld" ==
 
== Change "mysqld.service" -> "mysqld" ==

Revision as of 05:55, 26 May 2014

MySQL depricated pass prefix

When trying to import any database using mysql command or phpMyAdmin, I get this error: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Warning: Using unique option prefix pass instead of password is deprecated and w' at line 1

Two things that might be worth mentioning:

Password for DB root is limited to 79 characters (I was not aware of that as my password policy for databases was 80 characters after setting password I could not log in) If the one decides to reset the password then after everything is done but before loading services it might be worth killing mysql. I have done it simple way: ps ax | grep /usr/bin/mysqld and then kill it by PID (I guess there are better ways of doing this, I just appreciate this particular way). Hope this helps Gregosky (talk) 23:43, 29 August 2013 (UTC) Gregosky

Change "mysqld.service" -> "mysqld"

In newer versions of systemd we can drop the ".service" part, it's easier to read/type. Also only first time systemd units are mentioned it should link to systemd article. axper (talk) 17:51, 7 April 2014 (UTC)

We had a similar discussion some time back at Talk:Beginners' guide#service suffix. Most people seem to be in favour of keeping the .service, but no official rule/recommendation has been decided on yet. If you disagree or want to add to the discussion, please do!
--Lonaowna (talk) 20:03, 7 April 2014 (UTC)
Alright, so we are keeping it. axper (talk) 20:13, 7 April 2014 (UTC)