search

kla587 / Internet-System-Dev

0 stars 0 forks source link

Trying to connect with MySQL #31

Open kla587 opened 8 years ago

kla587 commented 8 years ago

Tried to install and configure MySQL to handle storing relationships. Used commands below to install and test MySQL.

sudo apt-get install mysql-server mysql-client --set password spdx sudo apt-get install libdbd-mysql-perl sudo apt-get install mysql-client-5.5

kla587 commented 8 years ago

Getting errors with connection in program. Set username and passcode to spdx during setup. Receiving error below:

DBI connect('database=spdx;host=localhost','spdx',...) failed: Access denied for user 'spdx'@'localhost' (using password: YES) at test.pl line 22.

kla587 commented 8 years ago

Uninstalled all databases on virtual machine and reinstalled MySQL. Tried to connect to database at command line and receiving error:

mikayla@mikayla-VirtualBox:~/Documents/perl$ mysql -u myusername -p Enter password: ERROR 1045 (28000): Access denied for user 'myusername'@'localhost' (using password: YES) mikayla@mikayla-VirtualBox:~/Documents/perl$ mysql -u myusername -p

Tried to research error and found:

http://ubuntuforums.org/showthread.php?t=1836919. Tried suggestions listed on page and still was receiving this error.

Used http://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38 to ensure I installed MySQL and MYSQL server.

kla587 commented 8 years ago

Then tried an update to my Virtual Machine to see if that resolved the issue.

Now receiving error: DBD-mysql installed ,but still error “install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC”

kla587 commented 8 years ago

Decided to uninstall and and try SQLite.