Login to MySQL as the root MySQL user and create the database that will hold the LiveJournal data:

$ mysql -uroot -p
mysql> CREATE DATABASE livejournal;
mysql> GRANT ALL PRIVILEGES ON livejournal.* TO 
     > lj@'localhost' IDENTIFIED BY 'ljpass';
     > \q

If you know what you are doing, you can set this up however you like. You tell LiveJournal how to connect to its database server(s) in your ljconfig.pl, as detailed in: Section 4, “Configuring %LJ::DBINFO”.