and I realized I had set a MySQL root password already. I tried using the following commands after that and kept getting access denied with password=yes.
So I basically ran the same commands but with a -p at the end, which prompted me each time to enter the password, and it seems to have went through. Now I’m at this command,
Exported variables last as long as he shell that exported them, just replace ${ASTERISK_DB_PW} (which will be undefined in a new shell) with the password you set for asteriskuser, best off though is to spend some time with a bash tutorial if you want to get the best out of your experience, the same could be said for your mysql interactions, sooner or late, you will REALLY need to understand why you are typing stuff, and not just hoping it will magically work .
I know that was a variable, I’m just not a Linux user, but I believe I may have found a potential error. The keyboard I was using has that “fn” key you have to press for certain keys, and whatever I was typing for the mysql root password is wrong, so I ran this command to change the mysql root password (not even sure if its the correct way)
dpkg-reconfigure mysql-server-5.5
I started the mysql steps again, I dropped the asterisk and asteriskcdrdb databases, and created them again using:
Connecting to database…FAILED
Try running ./install_amp --username=user --password=pass (using your own user and pass)
[FATAL] Cannot connect to database
Again, I’m not using the password variable as stated in my previous post, I replaced them all with what the password should be. What’s the proper way to reset the mysql root password with Ubuntu 14.04? All the guides I’m seeing are outdated.
Then you are doing it wrong, if you reinstalled mysql without a root password then you won’t need -p if you are root and if you did then it would have to be the same password.
for the syntax in calling the binaries:-
man mysql
man mysqladmin
man mysql (tab complete for all the choices)
There are many tutorials out there for how to interact with the various mysql binaries, you should read some.
An Ubuntu thought from the past, Are you running all this as root?
Then I have no idea. that methadology has worked for me for many years and is working for me right now on a brand spanking new VM, the only difference I can see is that I don’t use windoze, ever maybe the copy and paste is broken. I would start over from scratch and follow the script step by step, I can pretty well guarantee success if you are diligent.
Not sure whether it’s your problem or not, but Ubuntu and Debian servers automatically create a debian-sys-maint user and the credentials for that user in the mysql.user table must match the entry in /etc/mysql/debian.cnf. When those get out of sync, MySQL won’t start which means Asterisk and FreePBX won’t either.